I have a workbook that currently has information that will go to 2023 that I will be using for reporting purposes. I am trying to set up an automated workbook to have an automated tab that when information is inserted on the 2020, 2021, 2022 or 2023 tab (formatted as a table) that it inserts the new row of data on the next empty row on the "linked"/ overall tab. I was abIe to link the 2020 information but am trying to set up the other tabs to also go on the linked tab when information is added in the future. I am guessing this is not everything you need but please let me know what questions you have. I would prefer a non macro solution that a non tech savvy person (someone else besides me) can do as well please.
Linked data with 2020 tab
Linked data with 2020 tab