Copy data between worksheets according to date.

[delboy1616]

Hello all, I am new to macro's and would appreciate help, I have an issue with a macro that I need to copy data between 2 workbooks. One of the criteara is that only the previous months data needs copying across. Whatever the day the update occurs only the last full month i.e. (Sept) should be used this is vital. The second criteara is when the data is copied across it is enterd on the next empty row in the destination file. My source sheet is named 4x4, and the destination file is named D & T Totals. Is it possible to make this and automatic update on the first day of the next month or when the next time the destination file is opened. The custom date (dddd, mmm dd, yyyy) is in column "A"
Any help would be apperiated.
Thanks