Creating a Report Template

[StandingK]

I am attempting to create a workbook that would act as a template to generate a specific report. It requires multiple data sources and I am having difficulty working with all the sources to create a finalized list. Currently I take all of the data sources and manually run pivots and VLOOKUPS to get what I need. Any suggestions on where to start?

 

[sandy666]

Try PowerQuery, then you can generate result table or PivotTable as you wish