Automatically expand selection in Master Worksheet from linked worksheets

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!

1. Like this: http://microknowledge.com/link-excel...ltiple-sheets/

2. There's no similar option under Mac's "Data" tab. I've attached a screenshot of the available options under "Data" in Excel for Mac.

Note: I'm not pulling from an external source; they are spreadsheets in the same workbook.

Screenshot at Mar 06 16-51-31.jpg