SUMIFS Pull from Different Column, Sheet

Hello all,

I am an Excel noob so if this is a very simple answer I apologize/I'm ok with it. I tried uploading the sample Excel file that I created but it kept failing so I have attached a snip instead, if that works? I want to be able to have the formulas in cells C:K, M, and N pull the highlighted WBS # from Column A instead or, or in addition to matching and pulling the data from the Ledger sheet.

Right now I have to manually enter the WBS # in each formula line, and I'd like to be able to just reference Column A.

Does anyone know if that's possible and, if so, what I need to add/change to my formula? Any other formula that would work better?



Thank you!