title: Excel-how to make 3 tables dynamic with Auto Updated Range
body: <p>I HAVE SHARED SCREENSHOT OF MY PROBLEM.</p>
  <p>AS I HAVE 3 TABLES IN FINAL DATA SHEET.
  1ST IS DEAL SUMMARY TABLE WHICH IS EXIST IN DEAL SUMMRAY SHEET
  2ND IS CONTACT LIST TABLE WHICH IS EXIST IN CONTACT LIST SHEET
  3RD IS REFERENCE COMPANY TABLE WHICH IS EXIST IN REFERENCE COMPANY SHEET.</p>
  <p>SO, I WANT THAT WHENEVER I ADD DATA IN ALL OF THE 3 SHEETS, I WANT THAT DATA SHOULD BE AUTOMATICALLY PULL IN THEIR APPROPRIATE TABLES IN FINAL DATA SHEET LIKE DEAL SUMMARY SHEET DATA SHOULD BE IN DEAL SUMMARY TABLE IN FINAL SHEET.CONTACT LIST SHEET DATA SHOULD BE IN CONTACT LIST TABLE AUTOMATICALLY AND SO ON.</p>
  <p>AND ALSO, WHENEVER THE DATA PULL FROM THE SHEETS I WANT THAT TABLE AUTOMATICALLY INCREASE OR DECREASE THEIR RANGES ACOORDING TO DATA .ONE TABLE SHOULD NOT BE OVERLAP OTHER TABLE.</p>
  <p>ITS REQUIRED THAT ALL FUNTIONS I CAN USE UPTO EXCEL 2016 VERSION.</p>
  <p>IF ANYONE CAN HELP ..PLS REPLY
  [</p>
  <h2>enter image description here</h2>
  <p>]<a href="https://i.stack.imgur.com/liKKS.png" rel="nofollow noreferrer">1</a></p>