Copy and past from different sheets based on different criteria then sum certain columns

If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html