Copying Specific Data from One Workbook and Pasting to Another

I am very new to this but I am trying to create a Macro that will copy specific data from multiple workbooks into a single "Master File" workbook.

To be more specific, I have created a workbook with multiple sheets but one of the sheets tracks specific items in a given facitlity. I have 12 different people conducting the surveys and populating the sheet and saving it with their "zone number" in the file name. I want a macro that would run and copy the zone specific data from these other files and past it into my "Master File".

I have been trying to understand and modify some things from other threads but have been unsuccessful. I have attached a very simplified version of my workbooks. Book1 would be for zone 1, Book2 for zone 2, etc. I would like to take that data for each zone from the respective workbook and get it copied and pasted into the BookMaster.

I hope that makes sense and would appreciate any insight you can offer.

Yes, that would be fine.

One below the other in the same tab.

Sorry, that was just my example. Every file has a different number of entries ranging from 20 - 45 or so? What would I need to change?

I'm very sorry that was my mistake! Please accept my apology. I truly appreciate the assistance you have already provided!

This works very well with one file but once I put multiple files in the folder it doesn't work as desired. It appears to be writing the data over top of each other. Is there a way to make it write to the next blank row? Also, something strange happens with the column "A" output but I'm no sure how to describe that yet. It may fix itself one the rows write to the correct location. Thanks again for all your help!