I have 3 spreadsheets with different data for specific properties in this county. I need to combine all three into one speadsheet but the problem is the main identifier for each property is a TaxAcct. In each file they are not sorted the same. Meaning the data in spreadsheet 1 in row 2 is 2312830. The data in spreadsheet 2 starts with TaxAcct (row 2) is 2000120. In spreadsheet 3 row 2 starts with TaxAcct 2000001. Each row is data about a specific property. I need to combine all three spreadsheets into one with the appropriate info for each property in the same row. How do I do that without having to do it manually?

Does this make sense. I can send you samples of the three spreadsheets so you can see what I'm talking about.