How to: Turn Summary Sheet into detailed Sheets (multiple tabs)

I have a summary sheets for my report that my department no longer wants to use. Rather they want to have a longer, more detailed version of the same thing, but rather than 1 sheet summarizing it all, they want it 1 widget, 1 sheet.

How can I have my Checksheet tab (see upload), turned into multiple tabs. In the specific example I provided, there are 10 widgets, so therefore I created the result in 10 tabs.

How can I get a macro to turn Checksheet tab into the next 10 tabs (see excel upload)?

I have attached the excel sheet of how my summary sheet is, and how it's supposed to look like.

Alpha... almost there.

In my upload, numbers 6-10 on the checksheet summary have an extra line item that says "JPA not provided". That is transcribed at the bottom of the page on their corresponding tabs 6-10 in red again.
Currently the macro doesn't have it.

Very good though. It's already a huge improvement over what I have.
Thank you

Thanks. That helped!

AlphaFrog, I have been testing the macro for a while, and there is a few hiccups that I wouldn't have noticed if I didn't test it for a while.

When I have (for example) more than one row of "notes", it only copies over into the new sheet 1 of those rows. Can you fix that so that it doesn't matter which order the (up to 3 different line items of notes) notes are?