Hi

I have the lots of sheets all set out in the following
format

A B C D E
15 JAN APC SUPPLIES GBP C19278 2652.25

There could be any number of lines. What I would like to
do is copy the data to a template I have set up.

I would like B1 to be copied to B6 on the template file.

With Columns A, C, D and E I need these copying to A16,
B16, C16 and D16 respectively.

If possible I would also like the name of the original
sheet to be copied to cell B10 and then to save as the
reference in B10 if this is possible.

Thanks

Jahson