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

Hi ask72883

You can try
http://www.rondebruin.nl/summary.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ask72883" wrote in message ...
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