Copying data from several closed Excel sheets to a DATA sheet

[sofas]

Welcome
I want a way that enables me to copy the data of 4 closed excel sheets to one sheet
3 columns C.D.F & lastrow )..file names TTC1 _TTC2_ TTC3 _TTC4 Copied into an excel sheet data same range C.D.F (C18)

And column G
The name of the sheet from which the data was fetched is shown along the column

 

[johnny51981]

Do you have a version of Excel that includes Power Query?

 

[sofas]

Do you have a version of Excel that includes Power Query?

Hello, I have the 2019 version, but I want the solution by
VBA