title: Mirror a single table to multiple sheets in excel using vba
body: <p>I have one table in the database sheet in which i would want to paste link to another sheet. However i realised that it is not possible using excel and vba. Is there any ways to reference these tables automatically? Equating the cell ranges is one way that i know of but it is extremely tedious because i have over 50 tables of such. Hard coding these equations are a trouble.This is a basic code I have done to copy paste a table . </p>
  
  <pre><code>Sub table()
  
  
  ActiveSheet.ListObjects("Table1").Range.Copy
  'This code will run only when the cursor is at activesheet
  
  Sheets("Sheeet2").Range("A2").PasteSpecial xlPasteValues
  
  End Sub
  </code></pre>