Create a year by year financial report

Hi there
I have a 2 spreadsheets that I need collating into a year by year report from 2014 to 2024, showing income and outgoings, so that I can understand where the money has come in and where it has gone out.

I just used AI to see how it described what I needed, so have added it here as it probably says it in a more eloquent way! Your help will be greatly appreciated.

AI suggestion for what I need below!
The overarching goal is to understand patterns in my financials to aid future planning and decision making. Having the information aggregated and analysed in one succinct report will illuminate areas of strength as well as expenditure that may need monitoring or adjusting. If executed properly, this report will be a valuable ongoing reference to evaluate performance and track progress towards my money objectives over the next few years. Fluency with Excel is required to seamlessly extract and arrange data from the source files into a polished deliverable within the allotted timeline. I welcome efficient and solutions-oriented applicants to help