>>What exactly do you want to achieve?
>
>The end game is faster, cleaner, more efficient code. Somewhere I got the idea that the spreadsheet could be set up and sent to excel with a single call. Sort of like =TableUpdate.

May be you can use a template? I haven't tried it myself, so this is just an idea.