SORT DATA SETS IN EXCEL DUMP TO MULTIPLE SUBSETS AND FILES

I need a smart Analyst to look at a big raw dump then filter different data sets into different easily accessible sub sets and files.

This is to enable different teams in different locations go straight to file of choice. Competed files will be added to a catalogue for easy retrieval.

This is an EXCEL/GOOGLE SHEET TASK

Thank you.