Updating Dashboard of 'Linked' information based on criteria found in Master Worksheet.

Hello,

I wish to setup two separate dashboards with the following attributes:

1.) Search Criteria: Type of Machine (BT, RT, TC, XO)
2.) Based on the 'Type of Machine' in Column E on the Master worksheet the data is 'linked' to a different worksheet(s) (Shop_Floor_Dashboard & Receiving__Dock_Dashboard)
3.) The information linked/displayed on the Shop_Floor_Dashboard is columns B, C, G, K, L, M, N
4.) The information linked/displayed on the Receiving_Dock_Dashboard is columns A thru V
5.) Each dashboard is automatically updated when the 'Master' worksheet is edited by a certain individual who maintains the information.
6.) If a person adds to or deletes from the 'Master' worksheet the respective dashboards are updated automatically.

Any help is greatly appreciated!
Thanks & GOD Bless!
Chad