title: Data extract from one worksheet to another worksheet
body: <p>I hope someone can help me because I have tried many suggestions from other sites, but can not find the solution. </p>
  
  <p>I have one Dashboard Spreadsheet and nearly 30+ Department Spreadsheets (see attached snapshots).</p>
  
  <p>Which would be the best way to obtain data I soon as select "Department" Name (Department name and respective worksheet and spreadsheet names are same)</p>
  
  <p>Can you please help me with vba or macro?? Thank you very much!!</p>
  
  <p>Spreadsheet received from different department:</p>
  
  <p><a href="https://i.stack.imgur.com/qxg7b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qxg7b.png" alt="enter image description here"></a></p>
  
  <p>Summary/Dashboard Spreadsheet</p>
  
  <p><a href="https://i.stack.imgur.com/sGmsn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sGmsn.png" alt="enter image description here"></a></p>