Code VBA - command button update database

hi all,
I'm trying to build a time sheet database where each team member can fill in their time spent per week/day/project/project phase. I have build a worksheet for each member; they all look the same and include row 5:25 all projects and on columns I have Monday-Sunday (C4,E4,G4,I4,K4,M4,O4) and for each day a description cell where they can fill in the project phase from a drop-down list (D4,F4,H4,J4,L4,N4,P4). Above I have the team member name (A1) and end of week date (B2). Then I constructed a command button "Submit" which should transfer the data into a database sheet where I have the following headings: End of week, day, hours, project, project phase, team member (A2:F2) and which I want to be populated automatically when they click on the button.

So far I have the following code but it returns only the first entry in the time-sheet, respectively the hours worked on Monday ("C4") on the first project ("B5").

Do you know how to develop the code to look also into the following project lines (B6:B25) and to the following days (E4,G4,I4,K4,M4,O4)? Thanks so much!!

Please Login or Register  to view this content.

Hello and welcome to the Forum. Unfortunately your post does not comply with Rule 3 of the Forum. Please correct the issue.
Rule
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

You're welcome, and Thank you for fixing it. it not only makes it look better and easier to read, but it's easier for us to copy the code, all we have to do is click the icon above your code (I just found this out today lol).
I forgot to ask this in my previous post...Can you attach a sample or the workbook with any code/UserForm(s) you may have with it?

Timesheet attached

(file removed by admin)

file attached
(file removed by admin)

As requested, I have removed your uploaded file from post # 6 (hope that was the correct 1?)

VVex, as requested, I have removed all of your attachments