Which formula to use to get data from 11 sheets to trial balance

Thank you, I tried to do it via Power Query, from eleven different excel files, to get one table. Generally it work fine. Mine issue was, when I changed one number in one of excel files, I refreshed power query and it was updated. But than out of this query table, I made pivot table myself. When I refreshed pivot table, it didn't update. Is it normal or I have to do it another way? In file you can see in green tab E2 it updated to 10.000, in sheet 2 where should be the pivot table, it did not update.