You still don't show any effort. You need to tell us at least how your code fails for you and what you expect the code to do. Note that the Selection object depends on interactive features that may or may not be as you expect them. Your best bet is to replace all instances of Selection by absolute references. Most methods like Open, Add or Range return objects which you can use for replacing Selection.

Also read the Microsoft Documentation on Excel.Range.AutoFill.