Vb code to copy data from one sheet to anothe

Hello,

My problem is similar to first one. I was able to solve with the solution provided by helper. thanks helper. But, if column Q contains blank cells in between then what will be the code.

I need to copy data from sheet2 and sheet3 to shheet4 based on the input selected in sheet1. So for e.g., if i select "Time" in sheet1 dropdown box , the rows that contain "Time" in sheet 2 and sheet 3 should be copied to sheet4.

thanx