Workbook Help

[PaulM2009]

I have a book with a worksheet for each day of the month. On the worksheets is a log of events. I need to add a summary sheet that can go through the individual lines of events and copy every line over that has a value of 1 in the R column. Any ideas?

 

[nbrcrunch]

Filter on column R. Select all, go to new sheet. Paste.

 

[PaulM2009]

I was hoping that I could avoid having to repeat that manually for 30 worksheets.