how to copy the discontinuous data in database to the template?

the location of the database and the template are not the same, so that I cannot use the range function.

For examples, I want to copy the column of "B" in database2 to the column of "A" in template1
copy the column of "C" in sheet in "B11" in template1,
etc

Also, is it easy to choose to print on template1 or templated2 or templated3? I mean not print on all template at the same time.

Thanks.