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?