Combining multiple excel sheets corresponding to name

Hello All, Looking for some help here. I have a large excel sheet with multiple names that repeat - simplified version here. This is my Sheet 2   Name Cat 1 Cat 2 Cat3 Cat4 Cat 5 Cat 6 ...