I'm working on an excel spreadsheet that calculates overtime from different departments in my company.

I have it working but need help with the copy cell function.

Example of my problem -
In my cell I have ="Department"!A1
In the next column cell I have ="Department"!B1

This is pulling the data from the worksheet "Department" and the corresponding cell
The row number one needs to always stay the same and the letter referencing the column needs to change with each cell
When I copy, it keeps the column letter and changes the row number (1,2,3,ect).
So I try and put a $ in front of the 1 to keep it an absolute ="Department"!A$1
But then when I copy the cell it copies the exact formula. It's supposed to change the column letter to the next letter in the alphabet.
I have to believe there is a way to do this, but I've spent hours searching the net with no luck.

Can anyone give me the correct formula?

Thank you.