VBA to separate three tabs form master and paste existing data's in it as "values" (no link to master when separated)

[nscaria00]

Good Morning,
I have a master excel document which has couple of tabs (shown in tabs to extract image). I am populating data's in three tabs (component, tools and logistics) from other tabs by using "=" function. But I need to extract these three documents before I send to customer.
I am looking for a VBA code to extract these three tabs from master and create another document (with these three tabs) and save with RFQ number from "Pre-review checklist" B1 cell.
In the extracted files, "=" function should not be there and the datas needs to show as values (i mean not linked any more to master file). Is it doable?
I can share the excel document if needs to.
Thanks,

 

[dreid1011]

That works well. Thank you so much. Just one more questions. If I need to keep Customer cells intact (meaning leave the formulas as such in the copied document as well similar to the ones we extracted from), is that possible? All the cells other than white and yellow color are Customer filled formulas. Attached image as example. I am sorry asking this.

Is it just that one sheet you want to keep formulas intact or all sheets?

 

[nscaria00]

Is it just that one sheet you want to keep formulas intact or all sheets?

All three sheets. It has same color pattern. Other than white and yellow color, everything is Customer applied formulas.

 

[dreid1011]

All three sheets. It has same color pattern. Other than white and yellow color, everything is Customer applied formulas.

Okay, I'll take a look at it this evening when I get home since I can't download the workbook here.

 

[dreid1011]

Are there formulas in the green cells on the Logisitics tab? The other two tabs aren't going to be difficult to work, but the Logisitics tab could get messy if all the green cells are going to have formulas you want to keep.

 

[nscaria00]

That's OK. I think it will get messy. I will work without formulas. Thank you so much for your help.