Hi everyone!

I'm new here and wanted to ask about a method I used to be able to perform on Windows easily, but am struggling on a Mac:

I have 7 worksheets with answers to frequently asked questions on our RFPs (Request for Proposals).
They all have the same column headers. They are organized in tables.

I would like to create a Master database that is populated by the information on all 7 worksheets. I don't want to copy and paste, because I also want the selections to automatically expand in the Master when a new row is added or deleted.

Any ideas? Thank you so much for your input in advance!