merge amounts for each sheet based on duplicates dates & one word

Hi guys
I would merge amounts are existed in column E for each sheet for duplicates dates are existed in column A based on word " CASH" is existed in column C and ignore amounts for duplicates dates if the word is "NOT CASH" totally.
the result in OUT sheet should create the whole report by make the headers in row 1
in column A will populate DATE and the columns B:F will populate sheets names and mrging the amounts for duplicates dates for each sheet , the column G wiil calculate amounts for columns B:F as the formula as I put it in column G.
after that should insert TOTAL row and sum for each column as the formulas I put it in TOTAL row .every time should delete data in OUT sheet before showing the whole data as i did it .
some sheets will not show amounts for some dates , so should show hypen , not zero and not blank the cells
finally I would deal with 4000 rows at least for each sheet . this is simple file and no need attach big data .

Please Login or Register  to view this content.

Your result for "DXE" for 08/01/2010 not from your posted file!

And the red higlightrd cells in ColumnA: I had to format as "mdy" using text columns as the appeared incorrectly in the macro output i.e 08/01/2020 was output as 01/08/2010.

Try

Please Login or Register  to view this content.