Hi there, I have over 100 tabs with assorted data

I want a summary on one page

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

I want to have include each tab name on the summary in column A with
the date accross the row

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

any ideas? many thanks