i've got a ton of data on sheet 1 that is my "running" database
(periodically updated). i want to keep that as my master sheet but have
second and third sheets pull certain lines out.

for example.
sheet 1 has 8 colums of data. if cell b2 has a date (non-specific) in
it i want all of row 2 to populate a row in sheet two. if cell b3 does
not have a date i want that row to populate a row in sheet 3.

can anyone help me with this? i've tried IFs and VLookups and a few
others but can't seem to get it to work just right.