Trying to do “mail merge” using only excel.

I have a huge amount of data that needs to be mail merged, but the file is too big to be created in Word.

I’d like to pull a row of data from 1 sheet into a better formatted second sheet. The dream would be to then highlight 5 rows of newly formatted data (that came from 1 row on sheet 1) into sheet 2 and drag in down and have all the data reformatted in sheet 2. When I do this, it looks great but it’s pulling the wrong row from sheet 1 because I’m dragging 5 rows. So everything comes in out of order. Tough to explain, I’ve googled as much as I can and have found no answers. If there’s anyone who vaguely knows wha I’m trying to say who can help I’d really appreciate it!