How do I pull certain data from several worksheets in one sheet?
 

My workbook has worksheets that contain different data. For example, Red,
Blue, White, Purple and Pink. I only want to pull the all the data assoicated
with Red into a separate worksheet. Can this be done? I've tried VLookup and
it doesn't work because it does recognized any values.

PLEASE HELP :)