Hi, I encounter a problem and not sure how to continue from here. What i would like to do is:
First, Copy sheet 1 from all the worksheets into this new workbook where i have my macro run. (this i have no issue, here is the code)
Next, as I copy these sheets from their respective workbooks, I...