Why are you using VBA for this? This will be much, much quicker and easier with Power Query (get & transform). There are a lot of videos on YouTube to give you a jumpstart with it if you are unfamiliar with it.