Thanks Don, I was just wondering where to put that formula.

My master list is on Sheet 2 and I need the value in column H (3-12) to
transfer its row (ex: A5-J5) to the sheet corresponding to H (3-12).

So if H5 reads 7 then A5:J5 have to move to the next available row on sheet
seven.

Thank you for all of your help so far.