Are you able to split an excel sheet with multiple tabs in several individual sheets based on an indicator?

Good evening. I have a main report with around 8 tabs on it, each tab has info for a different product sold, and up to 100 sales people's data on each tab. I have to make individual reports for each sales person, but I'm wondering if there's a simple way to do this automatically based on their names that would make a new excel sheet for each person and for each tab they are included on?

Like Salesperson 1 will have data on 3 tabs, while Salesperson 2 will have data on 7 tabs, but their automated reports come in with 3 tabs and then 7 tabs respectively on their sheets?

I've never worked with Macros before, is this something that could be done without one or would I need to look into that?

I really appreciate any input here, I am just trying to find ways to preserve my sanity rather than doing everything manually. Thanks!