Transposing changing data into a data collection

[Tash]

Hi,
I am very new to all this posting threads so I hope you can bear with me!!
I have a worksheet that I use as a template/cover page for batches of invoices (screenshot below). Every time I generate a batch of invoices I fill in all the fields on the template, print it off and scan them off to be paid. What I would like to do is every time I fill in the template have the info in the shaded area transposed into another worksheet to be collected as a running log so that all my invoice info for the financial year is collated. With this done I can use it as my data set to create a pivot table with all the budget info against it aswell. I can copy it through and link the sheets but I cant work out how to have it running on so that I capture everything entered into the template.
My skills are very basic and self taught & I don't understand a lot the terminology. Any help would be appreciated.

 

[Hui]

Tash

Firstly, Welcome to the Chandoo.org Forums

To do what you want you'll need a simple bit of VBA and a Button to run the code
Can you post a sample file with the data so that we can supply that for you?
Also add any notes to tell people the data,logic behind what you are trying to do