Macro to copy data from 1 wrksheet to another

Hello,

Here is my situation. I have a workbook that has two sheets. The first sheet returns a set of cell values based on a link to an external database. What I need help figuring out is what function/macro can I use to copy Column A (Division) and Column B (Location) from the returned data set into the second worksheet regardless of the range of data because the values that the function/macro populates on the second sheet will then be used to return data from a second external database.

Ex:

In 2012 I run my script to pull data from the external database into the first worksheet. The returned values are as follows:

Division Location

110 210
120 220
130 230

The second sheet pulls those values into specific columns which in turn are used to return data from the second external database.

In 2013 I run the same script to return data and get the following results:

Division Location
110 210
120 220
130 230
140 240
150 250

Basically, I need to ensure that no matter if there are more or less returned values from the first worksheet, my second worksheet will always capture each data set in order to be used to return data from the second external database.