Link two separate excel sheets to get automatic update of specific cells

Hello Friends,

I know basic excel but as per my new job requirement, I got a new task in which I have to link my excel cost report to another excel summary sheet in which I have to update monthly cash and expenses as well as monthly cumulative cash and cumulative expenses.

So In my project sheet, I have a revenue cost from client and expense cost for vendors. We are updating it on monthly basis for example input invoices and forecast etc. Now My manager wants a separate sheet in which he wants to looks how much our company is making and how much we have expenses for each project cost reports. Now I am working on 7-8 projects and therefore have that much cost reports. That cost report has been generated with detail formulas and tables.

Now in the cost reports, I want to link specific cell to another excel sheet and when ever I update that cost report, automatically the new excel sheet receive that update and when ever I want to open that sheet I can see that numbers I input in the cost report are automatically importing to new sheet.

Looking forward to hear from you. I have attached the new excel sheet in which I want my numbers to be exported automatically. example sheet.pngexample sheet.pngThanks.Project Name

attach your sheets