Ok, can you point out which columns in which sheets are involved in each of these actions?

For e.g.
I have a statement and an payment report that i compare and do a vlookup to match off the invoices. both of these reports can have thousands of lines on them.
Which sheets are you talking about and which columns...

etc...