The macros should be in a standard module rather than ThisWorkbook module.

ThisWorkbook is always the workbook containing the code.

With what you've posted:
ActiveWorkbook is the last workbook opened by the OpenUpFiles macro and
ActiveSheet will be the sheet that was active at the time that file was last saved.