If unique value exists copy 2 values to other sheet

Could this be done with a formula instead?

There are 6 columns in sheet2 but 13 columns in sheet1. Which ones do you need to be represented on sheet2? A formula can be used to bring over the data to sheet2, but I don't know how one could use formula's to change formatting.

You can use Autofill to select the two rows of data and drag down by two rows to add new lines with the formatting. Format painter can also recreate the border and formats, but not the line height.

Is automating the data fill with formulas and formatting manually acceptable? Or a VBA solution can be used to do both. If a real guru feels I am wrong about formatting with formulas, please let us know.

Maniacb, thanks for replying. From the data in sheet 1 I only need the data from column A> Column B in sheet2 and Column N> Column M in sheet2.
I was hoping that it would automatically add a row when the last empty one was filled.
I have attached a copy of the sheet with the data manually moved.

As a work around I am thinking of linking the cells meantime, I have recorded a Macro to add a row but unfortunately that's all it does, adds one row. What would I need to change to make it add a row everytime the button is pressed? New sheet attached