Table loses range and format after entering data

[clandestino800]

Hi Excel friends,

I am facing a problem with a table I created for a project in which the team members track their working hours.
For that they need to enter the following parameters: date (manually), workpackage (drop-down menu), Tasks description (manually),
amount of hours (manually). The table is set up to "activate" the next row after entering the data (in the previous row). The table works fine if the date is entered first,
but most people chose to copy and paste and the table loses format and range. The table shall expand automatically, even if content is pasted from other cell range.

Target

Result

Any ideas on how to solve this?

 

[Jeffrey Mahoney]

Is there any reason not to extend the table to have hundreds of extra rows?