Data missing in WorkBooka after VBA Macro SAVE AS due to ComboBox source is missing

Hi,
Got a Master Order Woorkbook that thanks to you guys was able to add a macro to automatically increase order number by 1 and save a copy of workbook to a location. Problem is that Master Workbook had 3 sheets and 1 contain ranges that are used for comboboxes in Order Sheet. When saved to locations it is missing sheet that had ranges. Another thing that would love to add a macro to email a copy to address in cell K6. Im really new to VBA. Thanks