Monthly Data - VBA - Joiner

[Fay1]

I have three questions regarding the VBA coding:

1- how can i apply the prevention code before closing/sharing the sheet
2- if i am using the code ( Selection.CurrentRegion.RemoveDuplicates Columns:=Array(1, 2, 3, 4, 5, 6, _7), Header:=xlNo ) to remove any data duplication within a certain code and its not applying what's the alternative/solution
3- what's the code for applying two data table in one master sheet - compounding

plz note that i am a beginner with the VBA.

Thanks,