Avoid Sheet Flipping When Run Macro

I have the following macro

Sub UpdataMainTables()
'
' UpdataMainTables Macro
'
'
Sheets(" Table ").Select
Sheets("Main Data").Range("B2:B1048576").AdvancedFilter Action:=xlFilterCopy _
, CopyToRange:=Range("B2"), Unique:=True

[Code] ......

I have 2 questions

First one about avoid the movement of this macro, as you can see it starts at one sheet but the job is in other sheet when i run it it goes to the second sheet to do the job,, how i can avoid showing the movement.

Second question about th last part of the macro,, it most replace words with no thing,, if these words are not available it givs me alert,, how i can eliminate this alert.