Can't you just copy to a scratch area, and pluck to your true
destination a la B1=Sheet1!A2 ? Alternatively: Is your recordsource an
Access table? Your recordset could be a query instead of a table, which
returns records with fields

UsefulField1
"Filler"
"Filler"
UsefulField2
UsefulField3
etc.

which orients correctly to your destination.

It's difficult to answer without knowing what your recordset is.