Sum Cells from Different Workbooks into another Workbook Based on Another Cell

Hello,

I would like to sum Column M "Amount" of two separate workbooks and add them to Column E "Amount Spent" in another workbook based on Column A "Budget #" of all 3 workbooks.

I have attached the two separate workbooks, "test budget tracker rq" and "test budget tracker sub," and before and after spreadsheets where I would like the sums to appear in "TEST - Budget Appropriations for help."

Could this also be done automatically so that as lines are entered, they will automatically be added to the "TEST - Budget Appropriations" spreadsheet?

I'm not sure if this makes a difference but both "test budget tracker" spreadsheets can be as large as 3000 rows and the "TEST - Budget Appropriations" spreadsheet will have about 200 rows.

Also, do these all three workbooks need to be in the same folder?

Thanks in advance!

I am using Excel 2016.

Thank you. I just acknowledged the other thread. I am not versed enough in VBA to follow so was hoping this thread with formulas would help me at the level that I am at in Excel.