VBA/Excel automated invoicing

Hi

Im looking to speed up my invoicing process and would like to know if the below is possible through Excel and VB:

I want to put weekly data in a spreadsheet and for it to read this information, generate an invoice which it saves to a PDF and also have some of the information from the invoice copied to a new workbook.

The new work book would be a file to upload the invoice details to Sage so I would be only wanting the info from maybe 4 or 5 cells copied.

How I imagine it:
WORKBOOK
Sheet 1 - Weekly import data
Sheet 2 - Customer
Sheet 3 - Invoice

IMPORT WORKBOOK
Sheet 1 - Invoice details for import

I think the best way to do this would be to have the VB in WORKBOOK Sheet 1 - Weekly import with a button and for it to read across the cells to calculate the information for the invoice, also looking up the company details in Sheet 2 - Customer returning the information on to Sheet 3 - Invoice.

From here I would want the invoice to automatically save as a PDF, titled account_number-invoice_number.pdf

As i would need information from the invoice to import in to sage there would be certain details I would need from the invoice copied to IMPORT WORKBOOK Sheet 1 - Invoice details for import. This would need to populate all the invoice details and move down a cell once it has done one invoice and start the whole process again until it has completed what info its been provided.

This is just an idea kicking round my head and I just wanted to know if this would be possible.

Thanks for taking the time to read and I look forward to you replies

Hi jmac1947 and xladept

Really appreciate the time you have taken to read and reply my post, I will get the info together and provide examples shortly maybe after the weekend.

Again thanks for the warm welcome and advice