I WANT DATA TO LINK WITH OTHER WORKBOOKS ACORDING TO CELL CONTENT.
 

I HAVE A WORKSHEET THAT I WANT DATA TO UPDATE ACORDING TO OTHER SHEETS IN
ANOTHER WORKBOOK ACORDING TO A NO.FOR EXAMPLE:IN ONE WORKBOOK IS MY STOCK ON
HAND ACORDING TO PART NO'S. IN ANOTHER WORKBOOK IS MY VEHICLE'S TO WITCH THE
PARTS ARE BOOKED. I WANT THE STOCK ON HAND TO CHANGE IF I BOOK OUT THE PARTS
ACORDING TO A PART NO. I AM USING MICROSOFT EXCEL 2003