Macro copy data from multiple workbooks to master

Hi Arlu,
i am getting same error code 9 but unble to resolve the issue can you please confirm where i nedd to change in above code.
and how can i save data directly in different drive.