I've created a sample spreadsheet to show what I am trying to do. Ideally, I want to be able to add a file to the "input" page, and then have the "export" page auto populate with as many rows necessary to put the file in each folder. The folders get dictated based on category.

I also want to be able to update the "Categories" page with more folders and new categories without breaking anything. I've tried using an Array formula that pulls the data, but the closet I have gotten was that it populates the filename X times in a single cell, rather than creating a new row for each. I put formulas in C2 and D2 on the "export" page that I have tried, but I'm not even 100% sure I understand what they are doing. Just trying things I've found online, but no luck.

Here is my example spreadsheet.

Any help is greatly appreciated!