create a automatice invoice from a data extract

[s2m]

I have a data extract listing several different vendors and the items they
have sold. I can create a Pivot table that totals up the items per vendor.
What I want to do is automate a invoice form from the Pivot table data.

Thank you