tracking sheet and searching form for historical sheet

[omanparts]

Dear all

Thank you for your support in advance

My aim is to make tracking sheet for different project with multiple tasks and with the ability to close this tasks and but it on the historical data

Exempla

Project-1 has multiple tasks (Task-1/ Task-2/ Task-3) on column E we click the button for closing the Task and transfer the data on the historical sheet

[TABLE="width: 464"]
<tbody>[TR]
[TD] [TABLE="width: 464"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Project Name[/TD]
[TD]Project State[/TD]
[TD]Tasks Name [/TD]
[TD]Tasks State[/TD]
[TD]Closing button[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Project-1[/TD]
[TD]Open [/TD]
[TD]Tasks-1[/TD]
[TD]open [/TD]
[TD]button[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Project-1[/TD]
[TD]Open [/TD]
[TD]Tasks-2[/TD]
[TD]open [/TD]
[TD]button[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Project-1[/TD]
[TD]Open [/TD]
[TD]Tasks-3[/TD]
[TD]close[/TD]
[TD]button[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Project-1[/TD]
[TD]Open [/TD]
[TD]Tasks-4[/TD]
[TD]open [/TD]
[TD]button[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Project-2[/TD]
[TD]Open [/TD]
[TD]Tasks-1[/TD]
[TD]open [/TD]
[TD]button[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Project-2[/TD]
[TD]Open [/TD]
[TD]Tasks-2[/TD]
[TD]open [/TD]
[TD]button[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i need VBA and form for entre on tracking sheet and searching form for historical sheet
khalid