|I'm still not sure that we are on the same page as far as the terms we are using. Let me define two terms and then ask that you use these terms when explaining what is happening. Keep in mind that I can't see what is going on with your system from where I'm sitting.|
Workbook: an Excel document containing one or more worksheets, typically with an extension of xls, xlsm, xlsm, xlsm, etc.
Worksheet: the individual sheets within an Excel workbook, represented by the tabs in the workbook.
Now, using those terms (not "file") please explain whether Europa and personal are opening as worksheets within the workbooks you are creating/opening (i.e. they appears as a tab in the workbook) or opening as separate workbooks.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.