Copy rows to master sheet

[Carolyn]

I have been trying - unsuccessfully - to copy rows that have a value
in a certain column to a master sheet. I want a command button to
update the master sheet. Upon update, I want the column with the
specified value to revert to zero.

Any help would be great.

Thanks,
Carolyn