Probably can be automated, but we would need a LOT more information if you need our help in building it. Otherwise, I suggest Chandoo's site for Dashboard information, or perhaps using some of the macros from here: http://www.rondebruin.nl/win/section3.htm
which are very helpful for copying/merging data.
Since the report is confidential i could not upload it in Public. Could you please provide me your mail id, i would forward it to you. It would be great if you could help me with the automation.
Hi Kokila,
While I do take on projects on the side, I'm afraid my plate is pretty full at the moment. You could try contacting Narayan or JeffreyWeir if you want to hire someone.
Or, if you can scrub the data to make it more anonymous, that would be perfect. We don't need to see the actual data here to help you in layout design.