Dear All,

I have a workbook with multiple sheets , final sheet has a data of all sheets , in the first sheet i want to select what results to be shown in that final sheet ,, specially the week and the LDM ,,, i am trying now using a pivot table in the first sheet but with no joy

Below image and file calrfying more
excel iss3.png
Test values.xlsx