Create multiple tables based on data in a spreadsheet

[ablits1]

Hi friendly excel friends. I was hoping someone may be able to provide some guidance on my issue.

Basically, I am trying to automate the creation of tables in excel based on data in a spreadsheet. I am connected to a sharepoint list that contains computer inventory, and when I refresh the spreadsheet, the data will reflect whatever has been changed/added etc. In summary, I want tables created based on the "location" column in excel. I am trying to make a process that requires very little manual effort to get the tables created, past refreshing the spreadsheet to reflect new data. I am not sure if this can be done with references/formulas/functions, hence why I am posting and expecting that a macro will be needed.

Sample data attached. See "Data" and "Output Needed" sheets. I would need the data from "Data" to automatically create tables in another spreadsheet. It would need to be dynamic because some sites may not always have data, and there will always be different amounts of inventory per site, per date range of the report.

Thank you so much for any help!!!!