macro/vba to divide data sheet into two sheet

Need to divide the data in data sheet into two sheets

1)Only those records should move to the newly created two sheets in which the Date of birth is in DD-MMM-YY format(12-Nov-15).Records where the date of birth is not in said format or is 0,blank,text, numbers etc should get skipped.

2)In the newly created two sheets the value visible in original data sheet should get pasted, and the formula should not get pasted.

3)Input box for, which columns I want to be copied to new sheets (As all the columns need not be copied).Not in term of header but column name like A,B,C,H,I,J

4)input box for, row range for each new sheet (like row 2-400 to sheet1, 450-650 to sheet2).It is not not necessary that all the data will be get divided into two sheets, so the row range for 2nd sheet should not get auto fixed by selection of row range for first sheet. e.g It may happen that records between row 5 to 400 will go to one sheet and records between row 450 to 600 will go to second sheet, rest of record need not be copied to either of sheet.

5)input box to, name the newly created two sheet

6)input box for, name of workbook to which I want to move these newly created sheets and provision for error message if the workbook to which I want to move these sheets is not open.

Thanks