Want to make 1 autoupdate worksheet from downloaded daily transaction reports in CSV files

[Shivkarangrewal]

Hi All,
I download daily transaction reports in CSV format in a single folder with name as current date like (26122022.csv), there is so many type of transactions like Money Transfer, Recharge, Bill..etc, and these transaction are with Fail, Refund, Success Status, I want to make a Master Worksheet which show Sum of each type of transaction Amount with success status and when I apply same formula on next cell source file name automatically change according to date show in first column in master sheet, kindly suggest what can i do to create sheet.
Regards
Shivkaran Grewal

[sandy666]

I suggest to use Power Query

[Shivkarangrewal]

Dear Sandy666
Thanks to Help, but don't have idea, how to implement to resolve my issue. actually i want when i download daily report file to folder, master sheet automatically add data to previous or give me sum of different items from downloaded sheet.
Regards
SK Grewal

[sandy666]

Data - New Query - From File - From Folder (I assume you have all csvs in one folder)
next you can do what you want, transform, sum, filter and so on.
for more you can read here: https://learn.microsoft.com/en-us/power-query/

sorry, no real examples - no proper solution