I need a macro to help me with data transfer from one workbook to others based on the value of a couple of cells.

This is my scenario:
In Workbook1, If B4 = the word "change" and F4 is less than or greater than zero, I would like Columns A:C and U:AB transfered into Workbook2
and If B4 = the word "Change" and F4 is equal to zero, I would like columns A:D and G:T transfered into Workbook3

I hope one of you gurus out there can help me with this. Thanks in advance for your help.