I have a sales tax workbook that has approximately 100 tabs. Each tab is uniquely named for a different city or county that tax is paid on. I am trying to pull the code assigned by the state for each tab (all listed in cell C1 of each tab) into a master list without having to copy and paste or doing the =cell value for each tab. I have read thru multiple posts and found formulas and macros for workbooks that have generic naming, but I have not seen anything for unique named tabs. Is this something that can be done? Below is a screen shot of where I need the information to populate from each tab. Any help is greatly appreciated.