Need help to write shell script

I am very new to write shell script. please help me it is very urgent.
I want to generate status log for my system everyday .

I have one master file which contains testcases name and product name .

The data is stored in different directories and i am extrating failuers for each system and storting in one file .

But now i have to generate status.log file in this format,

Host Version SiCat YRS nanocad PSD
Krachel 10 2 3 4 6
limo 9 3 1 3 0
limo 10 1 2 0 1

The accumalted file data.log contains fail testcases name
/users/daily/krachel/10/run
! /users/daily/test1
! /users/daily/test3
! /users/daily/tttt
/user/daily/limo/9/run
! /users/daily/test3
! /users/daily/yyyy
/users/daily/limo/10/run
! /users/daily/rrrr
! /users/daily/uuu



The master file contains data
/users/daily/test1 PSD
/users/daily/rrrr SiCat
/users/daily/tttt PSD

The product name we can hardcod in shell script

please do help me to write this script
But now i have to generate status.log file in this format,

Host Version SiCat YRS nanocad PSD
Krachel 10 2 3 4 6
limo 9 3 1 3 0
limo 10 1 2 0 1

You will need to be a bit more forthcoming with information than that I fear.
Where are the systems listed, or how are they identifed?
I think I see where version is coming from (as part of the directory name in lines from the data.log extract you show. I also see the system names you refer to for your example status.log - is that where they are obtained from?
What are, and how do you find what SiCat, YRS, nanocad and PSD are?
How does the data in the master.log file tie up with any of the other data?

The Master file product.dat contains all Test Name and corresponding Product Name.

The fails are in data.dat and i have to print accumalated failuers as per the productwise .

/users/deaily/Krachel/10 conatins host and version name . Fails contains ! infront of that row .

Please do help me

The status.log i am generating . You are correct the data is stored in directory form .
I am extracting fails from different directories and storing into one file .

I wrote a shell script . which is for loop , find the run.log and grep the "!" fails and stored status log .

Sounds like you are on the right lines. You mention the file run.log - this is a new one, I don't see that mentioned before.

What are you using to 'drive' the loop with your script?
What are you doing within each iteration of the loop?