need a macro plz...
 

I would like you to help me with my big problem
i need to make a macro that could seek through certain sheets of my
workbook and copy some cells' values in an other sheet (copy the row
from B-J) and stop when an empty cell is found. i need this to continue
until all sheets i demanded are checked