I have a situation in which a file is sent with many tabs. Every tab has the
same information just different part numbers ex. So I would like to create a
macro that would enable me to extract the data from each tab and input into a
summary tab which the Macro would include. But if I record a macro the tab
names and the number of tabs change with each file. Any suggestions?