How to append sheet titles to table names automatically, and fill them into formulas

I'm going to make this long and specific, to try and avoid confusion, and so that if there is a better way to accomplish what I want then I can change direction.

I am creating a spreadsheet to track myself and my Spouses expenditures every month, and then throughout the year. I have a sheet for each month, a combined Annual sheet, and individual Annual sheets for each of us. Each month only holds the raw data, in 4 tables, expense and income for both of us. Table names are the same across all monthly sheets, with the exception of the month being appended to the end of table name. Think "Bob_Expense_Jan". But I want to make this more general so that the table name formula is the same across all sheets, but the sheet title "Jan", "Mar" ext. is appended automatically to the end of the table depending on which sheet it is in.

The second part of this is on the totals sheets. I would like the first line of tables on these sheets to be the sheets titles as well with a generic formula to link it to that specific sheet. So were I to change the name of the sheet, both the tables within that sheet, and the column headers on the Annual sheets would change to match.

The purpose of both of these would be for the third part which is the append the table callouts in Annuals with the sheets it should be referencing, that way I can 1 single formula for an entire table repeated without having to manually each formula for each month.

Basically Instead of a formula like this:

=SUMIF(Bob_Expense_Jan[Category],[@Expense],Bob_Expense_Jan[Amount])

That I would need to change for each row. I would like something like:

=SUMIF(Bob_Expense_"append column header"[Category],[@Expense],Bob_Expense_"append column header"[Amount])

Let me know what you all think, or if there is a better way to go about this. Because the next thing I want to figure out is how to get excel to add a row to totals when I add a category(Expense type), or remove.