There are about 500 workbooks and in each workbook there are 11 sheets which should be consolidated as per Tab name need a macro (VBA coding) for the same.
All workbooks are in the same folder. Is it possible. Thanks in advance.