Need VBA to create new Workbook and name it based on cell value in original file

Hello.

I have two sheets attached for use as examples. I want to a macro in the "Sched_Example" file that will create a new workbook that looks exactly like the "Export Example" file (ignore formulas in that one), and then copy and past the info into the "Input" tab on the "Export_Example" file. I realize it's probably not ideal to create a macro that recreates "Export Example" each time but I'm not sure how to replicate this file most efficiently so that the data can be pulled into it.

Any help is appreciated.