Hi there, I have over 100 tabs with assorted data

I want to create a summary on one tab

I am having problems writing a macro to copy the data from each tab
onto the summary page

I want to include each tab name on the summary sheet in column A with
the date accross the row starting in Column B

i have written the loop - but am struggling to include the each tab
name

any ideas? many thanks

I'd look at Ron de Bruin's macro here:
http://msdn.microsoft.com/en-us/library/cc793964.aspx

Rob P wrote:
>
> Hi there, I have over 100 tabs with assorted data
>
> I want to create a summary on one tab
>
> I am having problems writing a macro to copy the data from each tab
> onto the summary page
>
> I want to include each tab name on the summary sheet in column A with
> the date accross the row starting in Column B
>
> i have written the loop - but am struggling to include the each tab
> name
>
> any ideas? many thanks

--

Dave Peterson