Dragging formulas

Can anyone help with this,    I am trying to drag formulas horizontally from different workbook tabs. However when I drag formula it changes the cell rather than the workbook.   i.e. following on...