Newer to this type of VBA coding, and is outside my wheelhouse. I am looking to get a macro written that would loop through a folder and pull in the sheet from each excel file into the template. I would need the loop to pull off of a folder on my desktop and input the sheet into the template. I then have a separate Data tab that has all the lookups already formulated for the sheet that would be getting pulled in. I need the macro then to copy values every time a new sheet is put into the template and then paste the values in column H and keep pasting in the next right column till the loop is finished. Please PM for the file would like to keep some confidentially.
Thank you for reading, and please reach out if interested.