Trying to have 2 worksheets add value to main worksheet using next cell available

Okay so I have a workbook with 1 main worksheet, 2 "copied" worksheets for individuals to use to enter expenditures. What I would like is when a value is entered into a cell on the individual worksheets, for it to go into the main worksheet.

Example: Individual one enters an expenditure to G7 and Individual two also enters an expenditure to G7 on another worksheet. I would like both expenditures to now be entered to the main worksheet. Individual one would be on g7, but have a macro say if G7 is taken to move over and enter individual two's expenditure to H7. All values will be entered between G:P.

Does this make sense?

Thanks!

Thank you so much for answering sourabhg98! Let me try to explain myself better...So I have 1 main worksheet then copied that worksheet for 2 individuals (3 total worksheets) and deleted irrelevant info in the individual worksheets. What I'm looking to do is have the values that are entered into each individual worksheet to show on the main worksheet, however, on the main worksheet, I would need it to skip the cells that already have a value in it.

EXAMPLE: Individual 1 enters a value into G7, I would like that info to be entered into the same row on main worksheet, BUT, if individual 2 enters a value into her worksheet on G7, I would want the main worksheet to enter the value into H7 since G7 already has a value in it on the main worksheet. Values can be entered from Column G-P in each row.

can you please tell that if user 1 enters data in H7 where should it go in the main sheet? I7?

So all 3 worksheets are identical as far as where expenditures are listed (columns G-P). Basically the main worksheets combine the individual worksheets into 1 main worksheet.

Example: Row 7 is Gas expenses. Ind. 1 enters his gas expense in cell G7 on his individual worksheet and Ind. 2 enters gas expense in cell G7 on her individual worksheet. So now on the main worksheet I would like ind. 1 and 2's gas expenses to be listed together. So Ind. 1 gas expense is now shown on main sheet in cell G7 but the ind. 2 also entered on her worksheet gas expense in G7 so I need the main worksheet to see that there's a value listed in G7 and now will automatically enter the amount into the next available cell which would be H7 and so forth until row P. Basically each row has 10 cells per row for expenditures.