Need help with making a formula for cells that move

Hey All!
I am still pretty new and so pardon any errors in terms that I may use when referring to excel.

I need another formula for my weekly budget spreadsheet that does a number of things. I don't know if it is possible though. I have a workbook with 5 sheets. The Itemized sheet has tables on it which I have constructed so that I just enter the amount I was paid in the top cell and then a formula distributes that amount up into the different cells below it that correspond to the different things I budget for weekly. What I need is a formula that will take a value from these cells and autosum that value from the last two cells in the Necessity sheet cells. Is this possible? I don't know what is possible. Cause If it could also add the date in the column next those cells when ever it enters the amount that would be amazing. Is it also possible to get the formula to underline the cell as well? I do this so I can easily look up the sum when balancing my books at the end of the week.

I am just trying to see if Excel can do most of the manual work for me and I just have to enter my totals and any credits or debits I make. If anyone needs clarification feel free to ask as I appreciate your time in helping me solve this. My issue is that I don't know what to look up to construct my own formulas and I don't have enough time to research. If need be I can post a sample file or take screenshots if that is easier. Thank you in advance this forum is amazing!

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks I will do that.