Using the construction budget to fill in actual costs based on invoices

Hello,
I’m not sure if this is a design question or more of a formulas question, so here goes. I’m brand new to spreadsheets.com and already love all the features you can do with data. I’m trying to set up a construction budget, based on the construction budge template on this site, and I’m trying to figure out if there is a way to have invoices associated with a certain cost code automatically add together and drop that number in another sheet that tracks the overall project costs by product codes. I sure hope I was able to ask that question in a way that someone out there understands!
~Be well and enjoy the day!
~E