Attempting to develop an inventory spreadsheet.

[bdmedic]

Need assistance in creating an inventory spreadsheet with Macros. Need to be able to search all workbooks by name, expiration date, low quantities, items used or removed during time frame.

Attached the working spreadsheet but will also need to add additional books in the future. Would also like to have macros for generating different reports of each mentioned.

Any assistance is greatly appreciated.

Brad