How to: Turn Summary sheet into individual detailed sheets?

At work we have been asked to stop using a summary sheet I had made years ago in favor of a new individual sheet. I like my sheet, but I have to go with the flow.

Is there a way for me to transcribe what's in my summary sheet into an individual detailed sheet?

My uploaded attachment has how the summary sheet looks like, and how each sheet is supposed to look like.
I even added a "Reference List" sheet that won't be in there in the future (unnecessary big file size), but just so the macro can be created.

In my final macro-enabled worksheet, the "Reference List" will be a separate excel document on a different folder.

Just as a note: Info from some of the columns come from formulas and parameter query's. I hope this doesn't change anything.

Edit: Forgot to add, that the sheets "1 - ###, 2 - ###, ..., 10 - ###" are how the populated sheets are supposed to look like.