title: Linking Data from One sheet into another on DropDown selection
body: <p>I am trying to create a Monthly Net Income/Expense Sheet. </p>
  
  <p>I have a small manufacturing firm and based on orders we receive i want to add monthly Expense and Income.</p>
  
  <p>I have created a small sheet </p>
  
  <p><a href="https://i.stack.imgur.com/ZYyfZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZYyfZ.png" alt="enter image description here"></a></p>
  
  <p>I have 3 sheets right now</p>
  
  <ul>
  <li>Orders List basically has Names of all orders i receive for example <code>Washing Unit</code>. I have defined a name so that it will be a drop down selection as can be seen in image as <code>Order Name</code></li>
  </ul>
  
  <p>Now my <code>Washing Unit</code> is EXACTLY same as this sheet except it doesn't have <code>Order Name</code></p>
  
  <p>I want to know if I select Washing Unit from Dropdown how can I link the entire Row data into my <code>Washing Unit</code> Sheet</p>
  
  <p>e.g if I put Description and date,income and expense and then i select Washing Unit, it should be added as an entry in <code>Washing Unit</code> sheet and if I select None it will be removed from there</p>