Hi,
If I have multiple workbooks open and I want to copy data from only workbook based on the sheet name to another workbook again based on the sheet name, is that possible? The workbook names are variable.
For example, if I had 5 workbooks open with file names A,B,C,D,E.
In workbook B, there...