Combine multiple spreadsheets, using common columns and combining any duplicates

Hi, I am trying to figure out how to combine the spreadsheets on the attached workbook into 1. In the example attached I only included 1 or 2 items from each spreadsheet because I needed to change some info to attach it here. But,
the columns data in the rows on each spreadsheet can range from 0 to a couple thousand. I need for the columns with the same headings to be all under the same headings.. as it is now each spreadsheet may have the column names in different areas, and each one may have a column unique to just that sheet. So, the final spreadsheet would need to include all of the columns listed from each report (1 of each).. the other variable here is column A, the file number, if the file number can be repeated in the spreadsheets, but I need for the combined spreadsheet to only list each file once (and adding the data from that particular sheet) Some sheets do not have data, for that particular day, in that case, cell 2A = "No matching account found" - and that data does not need to be transferred.

Any help would be very much appreciated, thanks!