Auto populating data on sheets into a master sheet

I have a master sheet, and I will be duplicating other sheets and changing their name to the location as I go. I'd like to have the information from each location to be auto-pupulated on the master sheet. Not sure what vba function to use, please help.

Do you mean the workflow something like this ?

There is a button on a sheet with a name MASTER.
There are other sheet with a name AAA, sheet with a name BBB, sheet with a name CCC.

After you click the button in sheet MASTER:
- appear an input box and ask you to type in the input box the name of the sheet that you want to duplicate

After you type (for example) : BBB then click OK,
- the code duplicate sheet BBB with a name BBB (2) on the left of sheet BBB.
- appear an input box and ask you to type the new name of sheet BBB (2)

After you type (for example) : ZZZ then click OK,
- the code change the sheet with a name BBB(2) into ZZZ
- the code put a text ZZZ somewhere in sheet MASTER

Not realy,
I have a master sheet, named "master"
and I have sheet AAA, BBB, CCC,... etc
Each sheet has the same headers (total cost, location name, stage numbers, date... etc)

What I want is for the headers to auto populate on the master sheet, instead of me manually inputting them evry time, the sheets AAA,BBB,CCC will be created on a monthly bases and could be 100+

Originally Posted by yaraalawami

Not realy,
I have a master sheet, named "master"
and I have sheet AAA, BBB, CCC,... etc
Each sheet has the same headers (total cost, location name, stage numbers, date... etc)

So, the master sheet also has the same headers like sheet AAA, BBB, etc..

What I want is for the headers to auto populate on the master sheet, instead of me manually inputting them evry time

Did you mean of the bold sentence like this ?
1a. you activate sheet AAA, copy the rows with existing data (right under the header)
1b. then you activate sheet MASTER paste to the last blank row
2a. then you activate sheet BBB, copy the rows with existing data (right under the header)
2b. then you activate sheet MASTER paste to the last blank row
3a. then you activate sheet CCC, copy the rows with existing data (right under the header)
3b. then you activate sheet MASTER paste to the last blank row
and so on until............

the sheets AAA,BBB,CCC will be created on a monthly bases and could be 100+

until the last existing sheet ?

Which means, if you have 100 sheets (which is not sheet MASTER),
then you will do 100 times copy paste from each of those 100 sheets to sheet MASTER ?

Correct,
but I don't want to copy paste. I want the data to automatically popup on the master sheet