Update worksheet 1 with data from worksheet 2 based on date validation

Hi -

First, please see the attached sample workbook.

In this workbook I have two worksheets; the first worksheet is a Master File containing four data elements:

1) Effective date
2) ID number
3) Quantity
4) Cost

The second worksheet is a Future Change File where the user can input a quantity change, a cost change, or both... based on the specified 'Future Effective Date' indicated on this worksheet.

Here's what I need to happen:

On the click of the Command Button in the Master File (Sheet 1), I want Excel to :

a) Lookup each ID number in the Master File (Sheet1) and find it 's corresponding row in the Future Change File (Sheet2)
b) If the "Future Effective Date "shown in this corresponding row is today's date, Then
c) Update Master File with new quantity and/ or cost accordingly
d) Update the effective date displayed on the Master File with today's date
e) After update is complete, remove the item record from the Future Change file

Thanks for any help!

Grilleman