Macro to copy row into existing worksheet when data entered

Hello,

I need some assistance in developing a macro for the following scenario:

I have a series of tabs in one worksheet. In each tab, I have entered numerical data and text in Row 3, Columns A thru Z. The first column (column A) has a date entered. I would like to develop a macro where if the user selects a specific tab (let's call the tab NumberOne), it prompts the user for a date, and enters that date into Row 4. Then, I would like the macro to copy specific data from several select columns from Row 3 (Columns B, C, D, and Z) into Row 4 of the same tab, same worksheet.

Any help would be greatly appreciated.

Thanks!

attach please a sample of your file and give more details

enters that date into Row 4

where ? wich cell ?