Marco to update sheet first and then copy

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...

 Call UpdateMain