Create a Macro in Excel to pull information from Sheet 1 and summarize in one of three tabs

Job ID: 32861415

Budget: $10 – $30 USD

I have an inventory spreadsheet with stock at three different warehouses. I want a Macro that is going to pull the information from one Sheet and sort it and put it in one of three Tabs for each warehouse.