Google Sheets: Pivot Table - How to copy sum value onto another sheet

I have set up 3 sheets in Google sheets in related to budgeting/expenses.

The first contains the full budget (say Sheet A for example); The second contains the individual expenses (Sheet B); and the Third contains the pivot table (Sheet C), which helps to group together all the different expenses from Sheet B into categories (say for example Category A, B & C)

The pivot table is used to separate all the expenses into their relevant category and provide a sum total of the amount spent within that particular category. I want to copy this sum total amount to Sheet A (under the column 'Requested')

At first, I set a simple formula ='Sheet C'!C8

But the problem is, every time I add a new expense to Sheet B, the sum total value in the Pivot Table sheet (Sheet C) will be moved down to say C9 and so on. Is there some kind of formula I can use to copy the sum total value to Sheet A?

This should be achievable with a VLOOKUP. I could give a more definitive answer if you can provide a link to a workbook.

Please check with forum staff (moderators) and make a request for them to allow you to post a link to a google sheets file that has some sample data.