Macro to copy onto a new row

[RJ10]

Ok, so I have one database sheet which is automatically updated.

Is it possible to create a macro which would copy data from one cell on one sheet and paste it onto a new line of another sheet.

i.e

Sheet 1

A1 = Thursday (this would update to whichever day it is)

Sheet 2

A1=Thursday
A2=Friday
A3=Saturday
A4=Sunday
A5=Monday

Etc, etc

If it's possible it would be a great help. Cheers.

EDIT: If its possible to achieve the same goal without the use of macros, vlookup or something, then any help with that would be appreicated. Thanks.

[royUK]

This has been covered so many times on the Forum, a quick search would save you time.

See the contacts form example here

http://excel-it.com/vba_examples.htm