copy cell infromation from workbook to workbook
 

i would like to copy infromation in cells certin cell in woorbook 1 and
create a running list of infromation in woorkbook 2. i have created a PO in
excel and would like to copy the main infromation like vendor, PO#, cost to a
seperate wookbook and have it automaticly copy it to another work book so i
can have it as a list i can sort and keep track of when items arive. can
excel do this or would i be better of using something like acess? thanks for
the help
--
Randy