Excel VBA Code & Formatting

Hello, I am new to Excel, and trying to write code for VBA, but just found myself spending whole day on it and running in to error all the time. I attached Utilization new template file, and what I am trying to do is: 1)A-Asset Inventory WorkSheet - Cell D3 I created a dropdown validation for "All, Owned and Rental". I need to insert a button "Hide/Show Rows" above D3, that will reffect dropdown selection. I need to be able to filter based on the D3 value. There are multiple tables in this spreadsheet, and I need to keep them this way without combining, that's why I can't use Autofilter option. All - suppose to show all vendors Owned - "Sunshine" Rental - rest of it ("Vendor1", "Vendor2", etc) 2) If you go to Equipment tracking Worksheet - purpose of it to track each equipment on a daily basis. So far I just used data from Table 1 for Separators in there, and each day will be selecting where it currently is. Since Data in this Worksheet is extracted from "A-Asset Inventory", every time I sort or filter data in there, it will reflect "Equipment tracking" too, however, the actual tracking by dates (D7:D14) are not being sorted, and it messes up everything. I tried to put them independent / set down as a column, still it's not changing while the rest of the data is being sorted.