Creating Budget

I am trying to create a budget on Numbers for Mac that does a couple things:

1) Whenever I input my income, I separate it into the different envelopes as shown in the picture below.

I want then for each of those amounts, as well as the date, to be put into a separate spreadsheet/page named from the categories already mentioned. I sort of figured out a way to do that, HOWEVER...

I also want to be able to add transactions to each of those separate spreadsheets. So when I spend money or am given money not from my paycheck, I don't want to disrupt any formula that is populated. And I don't really want to manually add that formula back in each time.

2) I'd like to also be able to populate a separate spreadsheet with whatever transaction has a "CC" in the notes (for my credit card transactions) That I wouldn't need to really add to that sheet, but I would want it to go by date.

Let me know if you have any questions or need any further pictures!

Thanks!