I'm new at Excel so sorry if this is the dumbest question you've ever seen.

I am trying to fill across a row but I want the data to fill like this:
=Sheet4!M6 =Sheet4!M7 =Sheet4!M8

But all I can seem to get Excel to do is fill it like this:

=Sheet4!M6 =Sheet4!N6 =Sheet4!O6

I am assuming that the problem lies in the fact that the other sheet is
oriented in a column where as this is in a row. Is there an easy way around
this or will I have to just type in the correct formula in every cell?

Thanks.