In Excel, =$J:$J references a column, and ='Sheet2'!$J:$J will reference that column on Sheet2 explicitly.
Is there a way to reference column J and all sheets without manually typing all the sheet names?
You can try using 3D cell references.
For example, if you want to sum the contents of column J on all three sheets you can use the formula:
Creating a Name for your 3D Reference
This will make it easier for you to reference the columns.
To sum the contents of column J in
Not all Excel formulas can accept 3D references. Here are the ones that do: