Automatically copy only filled rows from certain sheets to one data sheet

[Summer2021]

Greetings everyone,

Hope you can share your opinions on this specific matter (I have looked for couple hours and haven't found this specific topic in the discussions).

I have created a task tracker for my team of 10 people. There are 10 sheets for everyone of us to fill they weekly tasks and one sheet with main data table where all rows with filled tasks should appear (also there are more sheets with other information). I tried power query, and it worked perfectly, but then I realised I had to make this file shared for everyone to edit it and It's not allowed when workbook contains tables (Office 2010)... So now I am trying to come up with vba code that would (automatically or not) copy*only filled rows*from everyones sheet (for example, everyone would have 10 blank rows to fill, From*B4-K4 to B13-K13*(without headers)) and copy them (when they are filled) to the main table which starts from*F14-O14.*

I can even pay for the solution, because I feel hopeless at the moment.

Thank you very much in advance.
Have a good evening!

[AliGW]

Administrative Note:

You have had the cross-posting explained to you before recently.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[Summer2021]

I apologize for cross-posting in two forums. The aim was just to find the answer in different platforms, different opinions. I have asked excel experts on mrexcel. com platform, but havent find the solution yet.

https://www.mrexcel.com/board/thread...sheet.1163232/

[Summer2021]

Please find the attachment below.

[AliGW]

You need to tell us where you cross-posted. You will not be able to post a link properly, so break it up with a couple of spaces.

As I said in the note above, you will get no further help until you do this.

As this is your second offence, I will not do it for you this time.

As you don't appear to have taken the reasons for the rule on board yet, please read the information I linked to in the note.

[AliGW]

Thank you for providing the link.