collect data from one excel sheet to another
 

I have one main workbook with a whole lot of onfo in it and when i open the
otehr workbooks then they must gather certain information from the main
workbook. I have this partially worked out in the following:

=IF('[MAIN TIMESHEET.xls]October'!$F5="BWC",'[MAIN
TIMESHEET.xls]October'!$B5:$I5,$B$79)

However, it is basically copying the info line by line and inserting it into
the other workbook on the same row number as where it got the info from. How
can i change this so that the workbook will add in the info starting from the
first row and follow through to the second, third and fourth row instead of
basically just doing a "copy and Paste" scenario.

Please help I am Desperate for an answer.