Thanks LJMetzger,
I have adopted the codes you graciously provided into my worksheet but upon the opening of the form I get the below error when i click the first (Port Arrival) commandbutton...

Sub CreateCloneSheet_error1.jpg
from the Sub CreateCloneSheet macro found in the ModFormSheetGeneration Module

I've tried looking for any differences in code in both workbook cant find any...pls help )