Marco to update sheet first and then copy

All your macro does is open the raw data sheet and immediately copy the data. I do not see any prove that the raw data is updated. You say raw data sheet is updated with a macro button.

my guess would be you will have to trigger the macro in the raw data sheet "Raw Data Lookup" to update before you copy.
I do not know the name of that macro but you can call the macro to action in your code.

I put a line in red where you should call the macro
I also cleanup your code from not needed selects and activates.

Please Login or Register  to view this content.

You are correct I want to trigger a macro in the "Raw Data Lookup" sheet before I copy the data. I tried your code but its giving me an error, the macro name called out is "UpdateMain" and this is how I called it out...

Please Login or Register  to view this content.

Ah yes.. have to call a different way for macro's in other workbook..
try the code below

Please Login or Register  to view this content.

Awesome, it worked . It takes longer to run the report though, so it proves that it is triggering the macro in other workbook.

Thank you!!