Macro that automatically updates pivot table when data in separate worksheet is updated

Hi,

Background situation: I have created a spreadsheet that tracks expenses (see attached). I have a control tab that lists the foundation for the information in all my other tabs. Then I created a transaction register which is where all the expenses are input. From the transaction register I created pivot tables used to update my dashboard tabs. I put a macro in the dashboard tabs that automatically updates the dashboards when the pivot table it refreshed.

Question: What I have been researching is how to have the pivot table update automatically when I update my transaction register. I don't want to have to click on the pivot table tab for it to update nor do I want to have to right click on the table to update. Essentially I would want to hide the pivot tables since they are only used as a means to the dashboards.

Macros are new to me and I had enough trouble creating the one that I did for the dashboard. And I have exhausted my google searches in hopes of trying to understand how I could do this.

Any help would be great.

Thanks!