A macro to update a main file from indivial, manual updates

Hello everyone

I have a 'Main work book' with all the months on seperate tabs. On each of these months holds the work that has been done by each principle.

For each principle, there is an invoice, listing ONLY their work.

When a payment has come in, I go to the individual invoice, and highlight the row green.

What I want my macro to do, is look on the invoice at the green rows, then find the relevant rows in the main work book - throughout the workbook... and make them green too, so at a glance, the payments will be highlighted on the main file.

So far, I have written my macro to select all the green rows on the invoice, and open the master file. That's it.

Any advice would massively help!?

Many Thanks,
BijouSolutions