I am working on an Excel workbook that has one initial sheet. This first sheet is a form that asks the users how many items in their project they have. The macro then generates a sheet for each item in their project.

Each generated sheet has buttons that perform specific functions, and these buttons have click events tied to them in the sheets code.

I have coded out all the functionality I need in the sheet in a static sheet.

I was wondering if there was a way to take this code and import it into all the dynamically created sheets once all the formatting and buttons are created by the form.

Any help would be greatly appreciated!