title: How can I extract data from master sheet to multiple generated sheets based on offset/string match into specific columns of the sheet in same workbook
body: <p>I wan't to copy N60 values and paste it in O17 cell and subsequently all other data from different tables into all worksheet of the same workbook in specific columns</p>
  <p>Data Format Master Table</p>
  <p><img src="https://i.stack.imgur.com/nUl3d.jpg" alt="enter image description here" /></p>
  <pre><code> Sub Data_Click()
  
  Dim wkSht As Worksheet
  Dim cell As Range
  Dim lastrow As Long, blankRow As Long, offsetRow As Long
  
  lastrow = Sheets(&quot;Combine&quot;).UsedRange.Rows.Count
  
  For Each cell In Sheets(&quot;Combine&quot;).Range(&quot;A2&quot;, &quot;A&quot; &amp; lastrow).Cells
  
      For Each wkSht In ThisWorkbook.Worksheets
      
          If cell.Value = wkSht.Name Then
          
              If cell.End(xlDown).Row &gt; lastrow Then
                  blankRow = lastrow
              Else
                  blankRow = cell.End(xlDown).Row - 1
              End If
              
              offsetRow = Application.WorksheetFunction.RoundDown(Sheet1.Cells(blankRow, 12).Value, 0)
              Sheets(&quot;Combine&quot;).Range(cell.Offset(0, 13), cell.Offset(offsetRow, 13)).Copy wkSht.Range(&quot;B17&quot;)
              Sheets(&quot;Combine&quot;).Range(cell.Offset(0, 18), cell.Offset(offsetRow, 18)).Copy wkSht.Range(&quot;017&quot;)
          End If
      
      Next wkSht
  
  Next cell
  
  
  End Sub
  </code></pre>