Make a worksheet self-adjust formulas when a row is inserted into a linked sheet?

Hi.

I have a workbook with several sheets, each of which is used for data entry for a specific type of revenue. I created the file so that each sheet has a specific number of rows available for data
entry. The last worksheet has links that carry all the data from the individual sheets to it, and it will be used to post everything to the general ledger all at once.

The file has worked great for months, but this month my boss needed to add some rows to one of the input sheets to accommodate some additional revenue. This, of course, screwed up the consolidation sheet at the end of the file because the sheet did not/could not add formulas for the new rows, so the additional information did not carry to the sheet.

Is there any way to make the consolidation sheet (the last one) self-adjust when someone adds a row to one of the data input worksheets?

Thanks!

Thank you. I will give that a try!