View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ask72883
 
Posts: n/a
Default Gathering Data from various tabs

Hi,

I have this massive file with some 60 odd tabs and I was wondering what
function would be the best way to approach gather data from each of these
tabs and putting it on the first sheet. Each of the tabs are structured the
same way so I would be grabbing simply the date and the data item (which will
always be in the same cell) for all 60 and putting them on the first sheet.
Any help is greatly appreciated.

Thanks,

Andy