How to unify two lists in one?

In this excel file I have a list of draw (dwg) that is generated by a macro automatically.
On a sheet the list of files (dwg) of a folder is generated (valid) and on another sheet the list of files (dwg) of the folder is generated (Canceled)
How to generate with the same macro or similar the list of files (dwg) of both folders in the Total sheet?

In your other thread I am have spent my free time to help you.
https://www.excelguru.ca/forums/showthread.php?9775-List-draw-and-Record-of-drawings-that-plot
You did not want to say, did it help?
You're not fair.

navic said:

In your other thread I am have spent my free time to help you.
https://www.excelguru.ca/forums/showthread.php?9775-List-draw-and-Record-of-drawings-that-plot
You did not want to say, did it help?
You're not fair.

Click to expand...

I'm very sorry, I did not mean to disrespect you. I did not read your notification
I'll look at it very well thank you very much.

Navic,
In this file I genre in a more practical way what I was looking for, I just need to unify the 2 columns in the Total Sheet