Macro Dashboard Setup Excel

Will need to take existing table of data and parse data into separate pivot tables and place in csv files. Will also need to create macros for unique search quires that will become repeated tasks. Once these task are completed will need to create user report or dash board for understanding of line data and instructions for what to do next.