Hi,
I have plenty of experience writing macros and scripts. I'm just wondering if you're really married to the idea of using a VB script in excel - you could achieve the same thing in a much simpler way using a command line script (like PHP or Perl).
The idea would be to open up the excel document in the script language, parse the data in there and then output the invoices you need to PDF format (the summary can be delivered as a separate excel sheet).
On the whole, though, it looks like you're keeping tracking of several different pieces of information (e.g. customers, addresses, invoices, payments, work done, staff member.... ). It'd be much better to consolidate all of this information / work flow into one suite (e.g. a locally hosted webserver to create a web interface). You would access the suite via your web-browser.
It would allow you to manage all those different pieces of information in one place, while providing you with any reports / outputs you need.
If you want to talk about that kind of solution send me a message and I can explain what I mean.
Thanks a lot,
John
ps: I just saw the other documents now (outputs required) - you can achieve what you want with spreadsheets, but I would absolutely recommend creating a suite to manage all your information. As your business grows it will become difficult to maintain these sheets, particularly if several people are using the same sheet.