Automated File Tracking System in Excel using OneDrive

I need a way to keep track of collected files automatically for reference by my team and another team.
I collect customer paperwork in pdf's, email messages as .msg and notes in files as .2do. I sort these into subfolders in OneDrive.
I need a sheet that syncs with a folder in OneDrive and lists what files I have and what I still need for each customer.

I made a spreadsheet that does some of what I want. It pulls the file names from the OneDrive folder and automatically creates a column with the company name and if there is a .2do file it pulls the name of that into the notes column.

I don't like how the company name is repeated on every row for every file. It would be better if every company was one row and the files were each in their own column and if it showed an checkbox for every piece of paperwork needed that showed as unchecked if its not in the folder.
Ideally I would like a progress bar that shows how complete the paperwork is based on those columns
I have 3 types of customer, each of which have different paperwork requirements.

I also want the Rep's name to be a separate column from the company name without changing the way the data is organized in windows.