Copy value in sheet 1 - Urgent.

--------------------------------------------------------------------------------

I have excel files with approx 80-220 sheets each.

I have used a "count" formula at the L200 on every sheets.

I want to display the count value at the first sheet against all the sheets.Like if sheet 1 have value 10 in cell l200 then the sheet one column C2 will show 10 , If sheet 2 /cell l200 has 15 value then sheet 1 cell C3 will show 15 ....and it will continue automatically.


Please help Its urgent.
Thanks in advance,
Fatalcore.


Sorry I posted the post in General section.