Hi everybody,

I am new to this forum & having a problem in preparing a report. My query is as under:

I am having around 200 sheets in a single file containing data. The format & the type of data is the same. The sequence in which the data is entered is also the same in all the sheets. In short, all the sheets are same except the figures entered are different, obviously. My requirement here is that I want to prepare a report in a single sheet in the same workbook which contains all the data of these 200 sheets. I know that it can be done by pressing "=" & providing reference to that cell in the respective sheet but in my case it would be a very long task. Just to further clarify, each sheet has around 30 cells in which the data is entered & as mentioned before, there are around 200 sheets. So for preparing my report I will have to give reference for around 6000 times.

I would be grateful if any one of you could show me a way out. Just to let u know I have no idea about VBA.