Hi guys I need you help!

I currently have 8 workbooks that are used by 8 different people. The workbooks are identical (same titles, columns) but rows can vary depending on how much data is entered.

each workbooks table range is up to 30,000 rows but most of our data tops up around 1,000 rows per workbook. I want to be able to import these 8 tables into one master one and for the life of me cant figure out how to go about it.

the tables are also primarily text so example of information in the columns could be

dec 10 - yes - no - failed - passed - pending follow up - etc..

can you please help and provide me direction on how to go about it!