Hi Thanks for the help,

I have attached a rough spreadsheet as I am only sketch booking at this stage. Essentially I have created a form on the tab 'Input' yellow cells the data in manually inputted and the green cells the data is selected from drop down menus.

My aim is to transfer the data into the tab 'DataSheet' with the press of the button on the 'Input' tab. This would preferably clear the form ready for the next booked meeting to be recorded. It would be useful to be able to create a ref no as well.ExcelHelp.xlsx

The end game is to be able to have one of these forms on each of the individual meeting bookers sheet's uploading to a central database.

Please let me know if you need more information?

Thanks

Tc