Using VBA to automate copy/paste on new Sheet

@kev_ thank you for the quick response.

I want one new summary page made from the each individual copy/paste, I don't need any headers and the range to be copied is constant on every sheet within the workbook, but the individual sheets will be different for every workbook.

Attached is the workbook I'm using. You'll notice there is a button named "Gail". That is used to copy/paste info since we have to take info and dump it into another program.

I'd like to be able to have one button on the index page that does that same copy/paste on each individual sheet into a new worksheet named "Gail"

The names of each of the sheets will change based on each job and there might be one sheet or 20. This is where I'm lost