query with filter or slicer to generate live multiple sheets

I have a query that contains over 400 rows.

One column contains an identifier that I'd like to be able to automatically filter onto separate sheets based on the data in that column. There are possibly 200 unique values in that column, so it would mean creating nearly 200 sheets.

I know that you can use pivot table options to do this based on a filter.

I also know how to do this very simply in google sheets with the formulas of query and filter.

I'd really like to have the ability to create these sheets en masse rather than individually. And I really need them to remain 'live' and update upon refresh from the original query.

***Edited to include attachment...Thanks, Ali!!!

Thanks,
Rachel

Yes, you can upload your workbook here, and please do so, as not all members are willing or able to access file-sharing sites.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.