If you can do it manually, why can't you record a macro while you do
it? Then you will be able to see the syntax and should be able to merge
the recorded macro (or parts of it) into your other macro. You could
insert two sheets "first_temp" and "last_temp", position them at the
appropriate places, then make use of these. Once you have finished,
"first_temp" and "last_temp" could be deleted.

Hope this helps.

Pete