Hi, i got a workbook named Login for user to add in new equipment, those details will then be inside a workbook named New equipment. There are several worksheets in the workbook(New equipment) the details are record in the various worksheets according to their type. The details include New ID, Description, Type, Date, and user name. Then if i have another workbook named Master record and i want the master record workbook to extract the data from new equipment workbook but only details like new ID date and user name and the master record must also be able to update its record when the user adds in or remove a equipment. How do i do that ?