Pivot Table from Multiple Worksheets Consolidate

[tariqjahangir]

1) Dear excel forum member, i have above 20 sheet are there i want to consolidate multiple sheet in Pivot Table to indicate data 1) Supplier Name 2) Invoice no 3) invoice date 4) Amount to display ( When I click to Slicer Month & Supplier name)

2) Which one is better to search multiple sheet data Provid table is better or some another way to search data ? that one also no problem
.
Data Sheet Attached

SUPPLIER INVOICE 26.04.2020 (1).xlsm

[oeldere]

I would add all data in 1 worksheet and after that 1 pivot table to analyse the data.