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
[TABLE="width: 500"]
<tbody>[TR]
[TD]A1 - Last Name
[/TD]
[TD]B1 - First Name
[/TD]
[TD]C1 - Job
[/TD]
[/TR]
[TR]
[TD]Smith
[/TD]
[TD]Jane
[/TD]
[TD]Biller
[/TD]
[/TR]
[TR]
[TD]Thomas
[/TD]
[TD]Bob
[/TD]
[TD]Biller
[/TD]
[/TR]
[TR]
[TD]inserted line here must be in Sheet 2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Young
[/TD]
[TD]Charlie
[/TD]
[TD]Nurse
[/TD]
[/TR]
[TR]
[TD]White
[/TD]
[TD]Michael
[/TD]
[TD]Nurse
[/TD]
[/TR]
</tbody>[/TABLE]