I've done an Excel Data Conolidation, and it works fine, however when expanding the Consolidation, it doesn't show the name of the worksheet its picking up the data from, it merely repeats the name of the workbooks... which is not so useful - any suggestions?
P.S I have a worked example I can email
P.S I have a worked example I can email