Not sure this is even possible, but I've been tasked with the following challenge:

As a regional nonprofit, the organization for which I work has kept two separate spreadsheets. The first sheet lists all donations made to the organization since its inception by donor such that multiple donations made by the same individual would still have the same ID number.

eg.

1 Jane Doe Date Amount
2 John Doe Date Amount
2 John Doe Date Amount
3 Jim Doe Date Amount

The second spreadsheet contains donor contact information sorted by Donor ID Number.

I need to find a way to sync the two workbooks such the donations made sheet sorts by the Donor IDs on the second sheet rather than by the arbitrary numbering system currently being used. While I could go through and do all of this manually, the list is rather extensive, and I have been trying to find a way within Excel of automating the process without actually merging the two workbooks into one.

Our Excel guru has recently retired, and as the unpaid intern, this project was tossed into my lap. Any help at all would be greatly appreciated as I am not highly familiar with many of Excel's more advanced features.

Thanks!

Jo