Hello. I have a tab that has rows with line items from a financial report (the items start with unique identifier numbers) and the tab also has historical monthly data for each of these items. I now have a new tab with the same line items but they are now in a different order. Is there a formula that I can use to copy all of the data from the old tab into the corresponding monthly line item in the new tab? Nothing changes except for the order of the rows.

Also, at the top of the old tab, there are totals that grab from each of the rows below. If I copy these formulas into the new tab, I think that they will referene the incorrect rows (as the order has changed) Is there any way to transfer these formulas and keep the linkage intact? Thanks a lot for any help!!!