Step 1. Save each worksheet into an individual file (you will need Developer tab enabled/visible to use the code below - File/Options/Customize Ribbon/Check 'Developer' tab on the right)