hi

you may want to look at this site for summary sheets

http://www.rondebruin.nl/copy2.htm

regards
Brian

cate wrote:
I don't think I asked the question clearly enough. Say I have 10 subsidiary
worksheets. On each subsidiary worksheet I need to reference cell D16 and
put it into 10 SEPARATE cells in the consolidated worksheet each cell
representing 1 subsidiary. Then I will write a formula in the consolidated
worksheet to sum them up. Does this make the answer any different. I
thought I read somewhere that I may be able to do a vlookup or ifsum to help
do this, but I'm not sure.

Thank you, Cate

cate

[quoted text clipped - 15 lines]

Thanks

--
bnt

Message posted via http://www.officekb.com