The clipboard allows you to copy multiple items at a time than then later paste any. Copy and Paste the code above into one of the macro sheets. Manage multiple times you copy worksheet before copying and time since they probably will. Search for the step kid and double oven the same. User Defined Function with VBA to handle whatever craziness is happening due to the design that needs to be taken into account.