Setting up a dashboard with a data source that can be updated by copy/pasting data into a different sheet

[ethicskayak]

Hi! I've essentially built a dashboard that has many slicers, allowing users to select various requirements and view which IDs are applicable to the given selection. I've built this dashboard via a macro, so that the user can just re paste the needed data into a sheet, click a button with the macro linked to it, and build the dashboard (with needed slicers and tables) based off of that copy/pasted data.

It works great on a single set of data, but I'd love ideas for a better way to build this out so the user doesn't have delete everything, and re run the macro every time they need to update it with new data, as well as reduce my possibilty for error in creating and editing the formulas and formatting through the macro. My biggest barrier to this right now is the slicers, since they are tied to the table that is built with the macro used to build out the dashboard.

I just started learning VBA, so I'm a total newbie with that, but any advice on this would be greatly appreciated! Please let me know if you have any questions or I can clarify anything about my issue.