I have a process where I want to merge multiple excel files into one file. All the files have the same data but saved by city name in one folder. Do I use the Copy Paste Range and/or the Append Range? I want to use a For each in Folder to get each file. Can anyone help