View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] maurits.vandenboom@gmail.com is offline
external usenet poster
 
Posts: 7
Default Getting info from individual sheets into master sheet

Hi Guys,

I made a database for personal information. I gave every person one
sheet with a fixed format. I have about 200 sheets now all named
according to the individual. Now I would like to have one master sheet,
the first sheet, in the excel workbook that list all the names of the
other sheets in one column and in the next column a cell that refers to
one cell in each sheet with a remark in there. This way I have one
overview from which sheets I need to change something and which ones
are ok.

I just don't have a clue how to do this. Is there an excel function or
macro function?

Would really appreciate the help.

Regards,

Maurits