How to drag SEQUENTALLY imported excel formulas from another document

Hey,
I´m facing some difficulties in mananing excel. I´m new here. Hope my question will be useful for anothers.

1.png

When I drag down the formulas, would make sense to be alphabetical logic sequential and that on the last line would appear the code !$H$2 and not !$B$2.
The code is imported from another excel document.
Can anyone help me out on this?

Would be grateful fellas

I apologize for that. Wasn´t involuntarily. I contacted the Admin to remove the duplicated post.