Copy Data from Multiple Worksheet to Master Worksheet

Dear All,

I have a File in which there are different worksheets are there with Each Equimpment Code as Sheet Name, Now i want to Copy the certain fields in Master file based on the Equimpment Code, sample file attached for your ready reference, please help me as the items are more than 100 and i cannot enter the formulas manually for each sheet