Inserting range and expanding cells in tables

Hi,



I have created a table shell on sheet2 of my workbook and I want a dynamic range from sheet1 (a list of the user's districts entered in column A) to populate column B of the table shells in sheet2. As it currently stands I've set tables in sheet2 to accomodate up to 50 districts. The problem is that the number of districts is dynamic and may be anywhere from 20-200 items long. I need the tables in Sheet2 to expand (insert rows and maintain formatting) to accomodate the dynamic list.


How can I copy and paste a dynamic list between worksheets and have Excel automatically expand the number of cells to fit my needs?



Thanks!

Katie