a micro that knows a row variable that is the date

[fophis]

I need a micro that can do a paste special in a row that changes every day. I have column A, the date, and I have a button that when I push it I want it to paste special the "number" of different cells on another page on the row that = the same date as the day that I pressed the button.