Help consolidating data/merging from multiple worksheets

Thanks Sandy, but that doesn't help me recreate it in my own workbook. I really appreciate the ready made solution, but i'm trying to adapt it to my own.