I need to do over 50 sumif formulas. They will look like this:

Sumif(range,value1,SheetX$A$1:$A$1000)
Sumif(range,value2,SheetX$B$1:$B$1000)
Sumif(range,value3,SheetX$C$1:$C$1000)

How do I continue this trend without re-typing the "SheetX$D$1:$D$1000", "SheetX$E$1:$E$1000", etc., etc., etc.,

Can I use some sort of indirect forumla? I have a helper column with letters A-Z and beyond but am at a loss for how to use it? There has to be a way to reference this list to make this more efficient, right?