Automatically Generate Invoices from Time Sheet (somewhat complex circumstances)

So, I've been a long time lurker here, and the forum has helped me setup my firm financials. It's been a great help.

I'm now looking to automate invoicing from a timesheet. Up to now, I've been using manual entry, which is prone to errors and take a very long time. That said, I'm wondering if I'm wanting to do something too complex.

The gist sounds simple but has proven very hard for me to figure out:

1) There is a monthly master time sheet with numerous timekeepers, numerous clients, a description, and amount of time spent;

2) There is a sheet that contains the clients and the rates each client pays for each timekeeper;

3) There is an invoice summary template; and

4) There is an invoice template.

I want to automatically produce invoices for each client that automatically populates the fields in the templates and calculates the amount owed by each client.

I've attached a file that shows all of this.

I'd appreciate any help at all. If it is a complex project, I'd be happy to pay for a result.

Thanks,

Will