Hope you all are well..
This forum site is more helpful site for me to fix up the issue's i have and had.. So Thanks to the Admin.
Now let me tell about my issue .
I just want to combine multiple workbooks in to one sheet which all are in different location and also i dont want to copy the whole workbook data..!!
Each workbook have a Sheet named as Prefix, This sheet value's needs to be combined in one sheet.
I have searched through out this forum and i haven't found any post related to my issue.
Guys can please help me here ?
I have to combine more than 20 files in different location ..!!
Many thanks in advance for all your help and time.