You have helped me a lot.... I dont know anything about excel pivot tables, macros etc... My requirement does not complete here.... The sample report i have given is not the full version.. it only a prat of it.... I actually have 5 such CSV files and need them to be copied to the excel report (i have given you has only 3 worksheets but the actual one has around 10 sheets with a lot of graphs). This is a daily report and I would like to completely automate it my using macro. Would you mind helping me with all my requirements (If you agree, it would be a great help for me but trouble for you ) ? If you can help me with all the requirements i could post the samples and request you for help... And if you agree i could give you my chat id (gtalk, yahoo, skype or anything and could do it through chat ). I am actually looking for more help online and as you it is very difficult for me to do the complete automation as I am a beginner.

Thank you very much once agani for your extended help. You are a star, I like helpful people like you.