Automate Tab Data Transfer

I have a single spreadsheet that already holds all raw information in “Tab A.” I need it streamlined so that: • “Tab B” automatically shows only the inventory information pulled from Tab A. • “Tab C” automatically shows just the product-detail fields from the same source... (Budget: $15 - $25 USD, Jobs: C# Programming, C++ Programming, Data Analysis, Data Management, Data Visualization, Excel, Google Sheets, Visual Basic)