Best way to create small files out of a bigger file?

[Sgligori]

Good morning. Each quarter I receive 4 HUMONGOUS Excel files. The data won't fit into 1 file, so I get Part1, Part2, Part3, and Part4. And with these 4 files I'm tasked to create smaller "Category" files. Basically, what I do is filter for each "Category", dump the filtered Category into a template, and then refresh the pivot table in the template. Those Category files then get sent off to different folks outside the company.

What is the best way to get all of my data in one place so that I can employ a loop to filter through each category, placing the filtered data into the template?

[Tinbendr]

I would export all files as text. (Or get the dump as a single file.)

Use Notepad++ to put all the files together.

Then use Excel's data tab to import the data I need using query.