Excel VBA programming - export data to spreadsheet

We have a excel spreadsheet where people can enter information. We need users to be able to click a button, which then checks if rows are empty or not, and if there is data to copy those rows into another workbook without any formatting. We also just need a simple date picker when a user clicks on a date cell.