Hi Jim,

Thank you for the reply. It sounds exactly like what I'm looking for, I had
thought of putting the control button on the worksheet called 'Input' as this
is the only sheet users need to access to populate the document.

You said to reply if I needed more help - my knowledge of macros is
rudimentary at best so yes please, your help would be greatly appreciated.

Thanks,

Phil