I have a worksheet called Paste_Data in a workbook that I have opened, I would like to copy data from 7 different workbooks from a sheet called AD_Change and paste the combined data to the Paste_Data worksheet.
I found code but need help to change it a bit so it works... Please someone help...