This my be confusing, but I will give it my best.
I have a workbook for my monthly budget. I have a main page, with my checking account transactions. I also have individual worksheets for the different segments of my budget (i.e. food, entertainment, transportation, etc). What I have been doing is copy and pasting the transactions from the checking account into their corresponding pages.

I want to be able to select the category in the checking account page, and as soon as I select that category on the account page, have it auto insert that data from the checking account page into its corresponding category page without me having to copy and paste. Any ideas on how I can do this??