Interlinked Multi-Sheet Excel Stock Tracker

I need a single workbook in Excel 2013 that will let me track 50-100 different stock items across six locations and one master sheet. Each sheet must share the same first column (Item Description), followed... (Budget: ₹600 - ₹1500 INR, Jobs: Data Analysis, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Visual Basic)