Trouble Importing Multiple Excel Sheets into Outlook Calendar

Hi all,

I need help figuring out how to import all the spreadsheets in a workbook into the Outlook calendar at one time.

I'm tasked with creating a workbook that contains information on all new hires at our company and their start dates. Each sheet in the workbook represents one new employee. I need to figure out how to import each employee into the Outlook calendar by their name and their assigned start date.

So far, I managed to figure out how to define a name for the range containing the Name and Start Date in the sheet but it only imports one sheet out of the whole workbook. How do I fix this?

I've attached an image of what it looks like.

Name_StartDate.jpg

Thanks for your help,
Tim