Delete duplicate older sheet

Hello everyone

I have a macro which combines different projects into 1 workbook with each sheet representing a different project. The project name is in cell A1 , the project total expenses is in cell V19. Sometimes it happens that I download the same project twice at two different dates but I want to keep only the most recent update, hence the one with the most expenses.

I need a macro which goes through all the sheets in the workbook and when it finds 2 or more sheets with the same project name in cell A1, it compares the values in cell V19 and keeps the sheet with the highest value. Is it even possible to have a Macro which does this, I don't know where to start.

Thank you in advance

It works perfectly. I'm amazed, thanks a lot man! I apologize for replying a bit late but I had problems with my laptop since I posted here.

I'm trying to understand your code and I'm still relatively new to VBA, would it be too much to ask if you could add some explanation to the lines to understand it better? Like for example the line "Set Dict = CreateObject("Scripting.Dictionary")" --> what does this do/mean?

Again, this is just if you have the time and feel like it, but the code works and thank you once more

Amazing, understand it much better now.

Thanks alot ^^