I have had a look at your workbook.

1. Please confirm that
- all hidden sheets should be excluded from the macro
- Sheet named "Index" is to be excluded from the macro
- all other sheets should be included in the macro

2. Where have you hidden button "Gail"?
(and I did not find any code for a button click event anywhere in the VBA)

3. What is the specific range you want copying from each remaining sheet?

4. When pasting into worksheet "Gail" the data will paste in sheet order

5. In worksheet "Gail", the rows from one sheet will follow on immediately from the previous sheet

6. Do you want a sheet identifier against each entries on Sheet "Gail"
- for example ColumnA could include the sheet name

7 Are you wanting the values copy/pasted
OR
do you want sheet Gail to contain formula?
(so that change a in value in a subsidiary sheet is reflected in sheet Gail

8 Is running the macro a once only event per workbook?
OR
is it a regular (eg monthly) task

9 Do the headings in "Gail" mirror those in copied sheets?