title: how to pull data from a sheet named as per value in the cell on a different sheet
body: <p>I have a multiple sheets in a workbook for orders on a same format and it will keep adding. Sheet name will be order number.</p>
  
  <p>I wants to create a Quotation sheet with a different format but same information from any order i want to print the quotation agaisnt. </p>
  
  <p>i am looking for a code or formula help to pick the information from Order sheet as per number / name on the quotation sheet. i.e. every time i change the number in a specific cell it pulls information from respective order sheet only. </p>
  
  <p>will greately appreciate your help 
  Thanks </p>
  
  <p>Naman</p>