Updating data from multiple worksheet in a master worksheet

[lilsheep23]

Invoice tracking example.xlsxInvoice tracking example.xlsx

Hi all,

I have been searching through the forums for an answer to this question so if someone knows of a thread they can direct me to or could help me with this problem, I would be grateful.

I have multiple service lines that generate invoices that I have created a standard format for them to list their invoices in separate spreadsheets. I want to then consolidate these invoices into a master spreadsheet (using the same format) that my office manager can then use to track A/R and record payments as they arrive. The payment information would then update automatically the Service Line's Invoice spreadsheet within the appropriate row.

Any suggestions would be helpful. I have attached a sample of the workbook if someone could assist.

Many thanks,

Tim