You can use this macro myasin
http://www.rondebruin.nl/summary.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"myasin" wrote in message ...
hi,
I have multiple worksheets, more than 200 of them, and i wanted to summarize
some cells in to one sheet, I know how to do it by entering the code manually
(='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that
like drag or something?