Export multiple tabs & Ensure that All links are disabled &formats are retained

Hi all ...

in the attached workbook, i have a "generate graphs" tab/worksheet

I was the user to enter the destination folder they want the reports saved in cell e13 of this sheet.

then i want the user to enter the name of what the want the workbook to be called in cell e16

from these two variables, I want some code that exports all tabs a, b and c to the destination folder with the above file name.

THE MAJOR PROBLEM:

i had a programmer do this and everything exports ok BUT, the workbook that gets created has LINKS back to this original workbook. I do not want ANY links on the exported workbook.

Also my previous programmer, found that he can Not get ALL THE Charts formats exactly the same as the original. when he does the export, the charts change to numeric values for dates on the x axis and the y axis (without the $ signs on the y axis and bar labels)

All the charts on tab a, b & c in this attached workbook have dates on the "x" axis and Currency $ Signs on the y axis... as well as currency $ signs on each bar..

I need all these formats to remain EXACTLY the same as they are in the original attached once it has exported. I want this to remain a Static copy without any links back to the attached workbook..

its like i need to have a snapshot of all these tabs in the newly created workbook.

I need the workbooks to be exported very fast with all the above mentioned intact..

I need help urgently.. my other junior programmer can export fine, but can Not retain all the formats exactly the same and can Not disable links to the source.. I need one of you very smart geniouses to figure this out and provide me a solution please......

each a,b,c tab refers to data in the "charts" tab.. I do not want the charts tab exported though..

please provide me a solution ... kindly put the working code in this attached workbook,please test to see the output is exactly the same as orignial and attach it to this forum post.. pleaseeeeee

Thank you SOOOOOOOOOOOOOO much everyone...