I am working with a workbook that has lets say 40 tabs in it. I want to create a summary tab. each of the 40 tabs are formatted identically and I need to extract info from the same exact cell from each sheet and put them in a row on the summary tab essentially creating a column with 40 rows of info. make sense? is there a way to do this?