Linking Worksheets
 

Hello all.
I am trying to link multiple worksheets to one worksheet and show
certain details on this worksheet.
Lets say that cell A1 on sheet1 contains someones name and cell A1 on
sheet2 contains a different name. I would like to show these names in
cells A1 and A2 on sheet3(Master) respectivley. I know I can do this by
using =Sheet1!A1 in cell A1 on Master and continue this down the column
, but what i will be doing is adding a lot of worksheets so i was
wondering if it possible for excel to account for new worksheets being
added and automatically input the names entered in Cell A1 on the new
"sheets" down Column A on Master.
Hope you can understand this.
Tony


--
Reefaman
------------------------------------------------------------------------
Reefaman's Profile: http://www.excelforum.com/member.php...o&userid=31968
View this thread: http://www.excelforum.com/showthread...hreadid=517454