Excel vba code

General information for the business: Business services
Description of excel work: Code to do the following:-

Copy a column of data from one spreadsheet to the next available column in a master spreadsheet - button to execute this

Code to "save as" a cell reference in the current workbook and save it in a nominated folder - button to execute this

Code to clear data when workbook is closed

Code to copy and paste data from one column to another removing the blank cells - executed by check box
Extra notes: