I am trying to determine the best way to setup my workbook and i keep going back and forth between pivot tables, VBA, and Power Query and can't figure out what is right. I have a data file with a large number of transactions and i want to have separate tabs display a subset of those transactions...