Hey guys,

I'm looking to create a dynamic invoice that has one main invoice worksheet that references a worksheet with client billing information.
Keep in mind that line items will differ between clients, and ideally I'd want to be able to:

Have date autopopulate, included in every line item
Select a client, which populates billing info as well as the invoice # nomenclature specific to that client
Be able to have client line items specific to the client populate based on the dropdown I select

Overall, no real specific guidelines, just trying to pick some other people's brains about how to approach a dynamic invoicing template. To preface, we have about 60 clients.

Thanks!

Ben