Welcome to the Forum!

Yes, that's possible. To provide further details, can you describe how the data is to be copied into the master file? That is, do you want each Sheet1 from each individual file to be copied to a separate worksheet in the master? Or are they all stacked up somehow in the worksheet in the Master?

I'm assuming this is strictly a copy & paste, and you don't need to do any of analysis or aggregation of the data.