Alright, so I will be as clear as I can on this, after trying to figure out the best way for months now / trying to create in Excel alone.

Want to:
-Export data from a website (CSV)
-Paste it into an Excel Template (Pasted into Sheet 1 / which according to fields- populates a table on Sheet 2)
-Create a visual Client Summary Printout/PDF from that Data using Publisher or some other Microsoft App that I have not yet discovered.

Is there a way to do this or am I wasting my time? I realize I could manually create a visual printout report in Excel, which is what I have been doing for over a year but it looks awful and even after tweaking the template almost daily, all it's left me with is a corrupt template. Any assistance greatly appreciated.