Required help for writing a excel macro

Hi all,

I am new in excel macro programming. I need a macro for update the
pending works lists as describes below.

#######

Master Sheet(Worksheet name: Master): contains the all pending works.

Different project works in separated sheets ( on same excel file):

Project Name: AAA Sheet name: AAA
BBB Sheet name: BBB
CCC Sheet name: CCC
DDD Sheet name: DDD
...
...
Total: 15 sheets.
Each sheets contains a column "N" with string data: "Finish" or "Pending"


I place a button in master sheet, name : "Update pending works".

I wish by clicking update button, all 15 work sheets pending works will
be uploaded in the master sheet ( Full row as each separated 15 sheets
have).

Could any one please write a macro function for update button??

#######

Thanks in advanced.

--ALAM