Macro to Link Excel Columns between Worksheets

[abyoung512]

I am using Microsoft Excel 2010 to work data between 2 worksheets in a workbook. I want to see that the data in Column A of Sheet 1 is populated into Column A of Sheet 2. I can do this with a Copy, Paste Special, Paste Link which allows me to change existing data in rows, but it does not allow me to add, remove, or sort data Column A of Sheet 1 and have the added, deleted or sorted data reflect in Column A of Sheet 2. I will need to follow a similar pattern for Column B of Sheet 1 and Column B of Sheet 2. I am fairly new to Macros and VBA Code, so I am having trouble figuring out the appropriate Code to use to meet my needs. Can you help provide me with Code and identify in the code what values I need to update to work for Columns A, B, C if needed.

Example - Sheet 1 Below

A1 - Last Name	B1 - First Name	C1 - Job
Smith	Jane	Biller
Thomas	Bob	Biller
inserted line here must be in Sheet 2
Young	Charlie	Nurse
White	Michael	Nurse

<tbody>
</tbody>