Import specific sheet with name and Date mm/dd/yyyy from closed workbook

I need to import specific sheet with name and Date mm/dd/yyyy from closed workbook. How do I do this with a macro?
File name would be "Import mm/dd/yyyy".xls