Live Filter Copy by Non-Unique Data, Not in First Row

Hey, all!
I'm sorry to bother you, as I'm generally able to find any Excel answers I need by Googling them. I've been out of the Excel game for a few years and am trying to dust off the cobwebs, haha! I haven't been able to find the answer to this problem yet after an hour or two of searching, so I'd greatly appreciate the assist.

Essentially, I need to filter a table by a column with non-unique data, that's not in the first column. I need this data for each of the categories that we're filtering by, and I have cells that will be referencing the new tables. I found that advanced filtering works, but I need this data to be live, and automatically updated when the raw data is changed. For example:
Capture3.PNG
In the above example, I need to create separate tables for each COLOR, with all the data for each of those relevant records. So like this:
Capture2.PNG

I'm ok with doing some crazy nesting functions etc, but it needs to be live, so that people that know nothing about excel can open the sheet, paste in new raw data in a single place, and have the filtered off-shoot tables updated through no additional Excel know-how.

Thanks in advance for your assistance!
~Steve

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

To add a file to a post

raw data f2 =C2&countif($C$2:$C2,C2) and drag down (as helpcolumn) (you can hide this if you want).

in F1 of each sheet the name of the sheet.

After that with index / match

See the attached file.

I made it for Short en Medium

Thanks for the rep.

You're welcome. We appreciate the feedback!

Thanks for marking the question solved.