@RPANovice1, I believe you would require the Macro to be modified to automatically include the 4 reports instead of asking the user for the file selection. If that is the case, could you share the Macro that is currently being used ? We could check for the modifications to be done and share the updated Macro with you.
Let us know if this is not what you wanted.