Consolidating data from multiple worksheets

Hi When Excel does a consolidation from different worksheets and the "Create links to source data" is ticked it will put the Workbook name in summary sheet and even though the sheets have different ...