List of items from another worksheeets

i am consolidating the list of items written by another person in worksheet A and would like to list them to my excel sheet as summary.
example:
excel 1
Worksheet A
column C5:F5 (merged cells) "Title"
column A1 "Number" (header) , from A10:A100 there could have blank or with value.
column B1 "Name" (header) , from B10:B100 there could have blank or with value.

excel 1
Worksheet B
column C5:F5 (merged cells) "Title"
column A1 "Number" (header) , from A10:A100 there could have blank or with value.
column B1 "Name" (header) , from B10:B100 there could have blank or with value.

At my worksheet:
Table column B10 "Title Description" to list the value written in Worksheet A C5:F5
Table column D10 "Item Number" to list all value written in Worksheet A A10:A100 , skip the blank.
Table column E10 "Item Name" to list all value written in Worksheet A B10:B100 , skip the blank.
Then the same capture the excel 1 Worksheet B, here i am not really sure how to make it as the worksheet A value can be varies and how to make my worksheet auto insert value from Worksheet B when all value in worksheet A has been captured. something like auto append next row.

okay, i have modified the question and attached the file.

Worksheet A1
column C5:F5 (merged cells) "Title"
column A8 "Number" (header) , from A9:A2000 there could have blank or with value.
column B8 "Name" (header) , from B9:B2000 there could have blank or with value.

Worksheet A2
column C5:F5 (merged cells) "Title"
column A8 "Number" (header) , from A9:A2000 there could have blank or with value.
column B8 "Name" (header) , from B9:B2000 there could have blank or with value.

At my worksheet:
Table column B10 "Title Description" to list the value written in Worksheet A1 C5:F5
Table column D10 "Item Number" to list all value written in Worksheet A1 and A2, A10:A2000 , skip the blank.
Table column E10 "Item Name" to list all value written in Worksheet A1 and A2, B10:B2000 , skip the blank.

Originally Posted by JeteMc

This proposed solution employs some helper columns on Worksheets A1 and A2 that filter out the blanks.
The array entered formula* that populates the helper columns is:

Formula:

Please Login or Register  to view this content.

Note: If your profile had specified the version of Excel you are using, it may be possible to use AGGREGATE(... instead of SMALL(IF... so this would not be array entered.
The formula that populates the 'Title' column is:

Formula:

Please Login or Register  to view this content.

The formula that populates the Item Number and Item Name columns is:

Formula:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

Thanks JeteMc !