I need a formula from cells 1-4 in cell 1
sheet 1, but when i drag I want a formula from cells 4-8 in cell 2 sheet 1,

I'm sorry, but I don't know what you mean by the sentence I just
quoted. Too much use of "cell" makes it ambiguous. I know you are
intending to use description rather than technical jargon. But, for
posting here, use actual Excel cell references like A1, D7, etc.
Technical jargon is preferred, so use as much as you can. If you use
the actual references from your file, someone can probably help you
with a precise formula and all you'd have to do is copy it.

At least call them Rows and Columns, if not actual references.