bring data from multiple sheets to one sheet based on name sheets

Try this code:

Please Login or Register  to view this content.

thanks maniacb but there is something in your code first of all in a8 it supposes 162 not ali and i would the items are serially as what i asked in my post
it supposes copy data as what i put in main sheet


it supposes the items this
147
148
149
150
151
152
153
154
155
156
160
161
162
172
173
174
175
176
177

To correct cell A8, Remove line:

Please Login or Register  to view this content.

For sorting the data and placing it all in order, one should not use merged cells. Here is code that will work without merged cells, placed after Next:

Please Login or Register  to view this content.

awesome ! maniacb the code works very good many thank