So, the first thing I see is that you ask for FirstFreeRow, but then you don't use it. In the very next command you only pull B1 to B3, not to B and %FirstFreeRow%. Therefore you will always only get 3 tax IDs (assuming no title row). If you do have a title row, then you want to pull B2 to %FirstFreeRow%.
From here, the logic is all backwards. Like @Agnius said, we just want to "Get Files" using the Tax ID on the proper folder. So the whole thing looks like this:
First, as an input variable, have the path that stores all the TaxID folders, i'll call it %TaxID_MainPath%
Open Excel Workbook
Get %FirstFreeRow%
Read from Excel B1 to %FirstFreeRow% (to get %TaxIDs%)
For each %TaxID% in %TaxIDs%
Get Files (Filter files for %TaxID%*.xlsx) here, the asterisk represents anything after, so it will pull in something like %TaxID%_Financials.xlsx.
Move Files %Files% to folder %TaxID_MainPath%\%TaxID% (the TaxID subfolder in MainPath)
End (for each)
This will read all tax id's from the excel workbook (to last row) and then will search for all files containing that Tax ID and move all those files to the appropriate folder before moving onto the next tax id. This stops you from having to read all files first and picking them apart one by one. It will be much faster and easier to build.
Good luck!
