vba excel ,,,,,................?

I have 23 files each file with 3 sheets that contain data about a city
The 23 files are for 23 different cities
I have to make a model that, when I open an excel file
There is only a button and when I press the button I got the 23 files in one file
So it’s a kind of copy paste the 23 files in to one file with 3 sheets
The first sheet contain the all data in the cities first sheet and so on for the second and third
How to do it using VBA