Sumif Across multiple Worksheets using Partial Tab Name

Good afternoon,

I'm trying to create a formula that will look at the name in a cell (from a dropdown list) and sum all worksheets that use that same name. For example all the tabs are named Division 1a, Division 1b and Division 1c, etc up through 23 divisions all with an a-b-c tab. The formula will need to look at the cell with the dropdown name and sum one cell in all three tabs of that same division.

Thank you so much for any help you can provide.