Im working on creating an excel sheet that will be contain a summary tab and several sheets that will be used to enter in information from root cause analyses that we perform. Each sheet will be the exact same. There will be areas for just text and fields that will have dropdown lists. I would like to summary page (the pivot table) to pull the information selected from the dropdown lists in each of the worksheets.
I would prefer this instead of inputting formulas in each of the cells in the worksheets and on the summary page because if we want to drill down from the summary page we will not be able to since it’s not a Pivot Table.
Hopefully I was able to convey what I am requesting in a clear and concise way.
By: Jamil Aslam