Vertical data to Horizontal from Sheet B to Sheet A

Greetings, Everyone!

I'm having a difficulty in encoding some data in my file. Sheet A contains running hours of equipment per day, the problem is, the dates are listed vertically downward, because per equipment, it has a formula for electrical consumption. Scrolling thru numpad arrow everytime i press enter is a bit time consuming so i created a Sheet B, where the raw data from logsheets will be copied to, the dates are listed horizontally and the equipment tags are listed vertically so that i can encode the data per equipment faster, since all it takes is pressing enter then the active cell will move to the next equipment.

i tried copying the data from Sheet B to Sheet A with ='SCADA-DOS'!B23 (for example), what i need is the progression of letter not number to make it faster, B23,C23,D23,E23,F23....and so on. however, i dont know what formula to use to make it happen, i tried dragging the existing cell downward but the number part of cell is the one progressing not the letter C23,C24,C25...and so on. is there any function/formula that i can use to progress the letter part (column) not the number(row)?

thank you in advance. hope you could help me out on this one.

Hi
Try this (adjust as needed) in 'Sheet B' in cell A1
=OFFSET('Sheet A'!$A$1,COLUMN()-1,ROW()-1)
Copy down and forward

i tried the offset, sir. but it didn't work.

if you have time, you can view the file that im working on to better understand my dilemma.

here's the link: https://www.dropbox.com/s/jr176prwq5...n_MC.xlsx?dl=0

I have a feeling that there's a formula for this, i just don't know what it is.