Conditional formating two reports for differences

Is this what you are looking for? You enter batch number is the grey cells and the Amount and Office are found from the appropriate report?
If not, an explanation of the steps you would manually take for one batch number would help in figuring out a way to automate it.