The attched workbook has a small macro included that will make copies of Sheet2 and rename them based on the names in the Reference tab.
I'd like to convert this to an add-in. I know how to make this an add-in in terms of changing the properties in the VBA explorer. What I need help with is updating the code to work against any workbook. Currently this will only run within this workbook.
I don't know where to begin to make this more portable, please help get me started.