Creating an inventory in excel with a master tab

Hello,

I need some advice.

I have created an inventory that has one master tab called "Full Inventory" and then individual tabs for each storage zone. I want the information added under the individual zones to be shown on the full inventory tab which is locked so it cannot be edited.

Is this possible? I am a novice with excel

Thanks