You could possibly use the VLOOKUP function to retrieve your data using column() as argument
So supposing your old data is in range A1:G100 in the new range in B1 enter
=VLOOKUP(A1,wkbk_name_and_sheet!$A$1:$G$100,column (),false) and drag right and down. Adapt to your layout if needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post