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