Rits wrote:
Oppss i am sorry i figured out how to do it

How did you do this? I am working with Data/Consolidation and cant get
it to work.

All I want to do is copy non-blank cells from worksheet 2, 3 & 4 into
the first worksheet.