Embedded Excel File

[vbakid]

Hello,

I need some help with embedded excel files within my excel spreadsheet. I have one worksheet within my (master) workbook in which there are multiple (upto 20 Max, min 3) embedded excel files. What I want to do is open each embedded file from that sheet and copy the sheets from the embedded file where cell A1 = Yes into my master workbook.

I.e. Master workbook contains sheets:
Instructions
SheetWithEmbeddedFiles - Which contains the embedded xlsm files

Each embedded xlsm file is of the same format, just the contents will vary. If A1 = yes, then copy that sheet into my master so the master now contains:

Instructions
SheetWithEmbeddedFiles - Which contains the embedded xlsm files
SheetFromEmbedded1
SheetFromEmbedded2 etc etc

I was able to open one of the workbooks through this

Worksheets("SheetWithEmbeddedFiles").Shapes(1).OLEFormat.Activate

but then I'm at a loss on how to copy the sheets from it and move on to the next embedded file.

Can someone please help? This is the last thing I need to do for my program and it seems to be the biggest hurdle

All help would be much appreciated, thank you