Run/Call a script

So I am working on a script that pulls several excel workbooks together into one. Some of my source workbooks have 'update" scripts embedded in them and before i copy the worksheets to the new master file, I want to run the 'update' script



'Copy Evoke LV - Sundries into LV CA-0
Workbooks.Open Filename:= _
"\\mhf.local\PrdtMgrPriceLists\Accessories and Sundries\Met West\Current Updated Version\CURRENT CAN West - Sundries.xlsm"
Call SundriesUPDATE
Sheets("Sundries").Select
Sheets("Sundries").Copy After:=Workbooks( _
"CURRENT CAN West - Price List.xlsm").Sheets(9)


FYI - Windows 10 - Excel 2010 V14.something or other.
"CURRENT CAN West - Price List.xlsm" = New Master
"CURRENT CAN West - Sundries.xlsm" = Needs to be copy and pasted into new Master
"SundriesUPDATE" = update script in Sundires.xlsm file


M

Hi, welcome to the forum.
Your question is quite vague but I am assuming that you want to run a macro when that file opens.
Well, you add the parameter to run that specific when the file opens.
Google for open excel and run a specific macro

If you need help with that, holler