Copy data in Range and paste into selected column

Hi there

Would really appreciate someones help please.

I have the following in a spreadsheet

Sheet 1
Col A: contains various numbers in the row e.g 23, 97, 254 etc (then Rows B to H contain various data)

A B C D E F G
1
2 23
3 97
4 254
5 588


I the need to look at the number in col A (e.g 23) and then copy the data cells B2:G2 and paste into row 23 in Sheet2 and then the same for the next number in col A in Sheet1 (e.g 97) copy data in cells B3:G3 and paste into row 97 in Sheet2

Thanks

Sorry header should say copy data into selected row