updating spreadsheet from another spreadsheet

[Guest]

i need to update spreadsheet(B) from a seperate spreadsheet(A) that is on a
share drive. i only want information that has been update, added, ect from
(A) to populate (B). With a color coded cell (yellow) showing that the data
from (A) is new when opening or manually running the macro on (B). (A) is a
master spreadsheet that i need only a few of the columns data to populate
(B).

i am using Excel 2003

thanks

 

[Guest]

also wanted to add that spreadsheet (B) will have data getting inputed on it
and i don't want that over written when new or updated data is entered on
spreadsheet (A).

thanks