Macro to copy (import) all open worksheets from one workbook to another workbook

[sdoppke]

Hi everyone, there is a lot on this topic , but cant find much to help with the "All open" part...

Im trying to create a macro that will copy all open worksheets from one workbook (workbook1) to another open workbook (workbook2). That parts doesnt seem to hard, but the stipulations are, it needs to import the tab names (as they are in workbook1) to workbook2, and copy over the formulas without the referenced sheet [sheet1], or in better words remove the brackets and all that is inbetween, but still leaving the formula.

Thanks everyine in advacne for any help or direction.

Also is it even possible to copy those worksheets (tabs) from a path, without even opening them?

sd

 

[sdoppke]

Thought it might help if I reword...

Trying to open a worhseet from a path,

then unhide all sheets then loop through all open workbooks excluding the "this workbook" (becasue the names of workbooks change based on date daily)

Then copy all open worksheets on the newly opened workbook over to the existing workbook (keeping all the original tab names) at the end of the workbook.

Most importantly leaving the formulas and hopyfully removing and [Brackets with refernced paths]


Really appreciate any ideas you have

sd

 

[sdoppke]

Hoping you all had a great 4th!! Anyone jave any input as to how to get this working?

Thanks in advance

sd