If-Then Copy/Insert Function

Hello,

I am trying to create an excel workbook to track our Sales Managers monthly progress. Currently, there are 5 "weekly" worksheets that track ALL CONTACTS(Sales/Non-Sales) and 1 "monthly summary" worksheet that only tracks ACTUAL SALES. They all look identical. Each worksheet has a column that indicates a sale (by the number 1). I would like Each Sale (indicated by a 1), from Each "weekly" Worksheet to automatically copy itself into the "monthly summary." (I then need to be able to do some SUM/COUNT functions, but the number of rows in the "monthly summary" worksheet will be variable??)

Please help!

I'm not able to open your attachment (Book3)

Try now...I've saved in an older Excel version