Hey,

Im hoping someone can help me with, what i think is an awkward issue, but may be simple to others.

I have a group of 8 workbooks in a single folder, each one containing separate worksheets for the names of a location of a branch of our company (brighton, cambridge etc)
Some workbooks have 6 locations/sheets, some have 20.

There are a couple of hidden sheets, but we can ignore them.

I need a macro to look at each workbook in the folder, search all unhidden worksheets at column Y for non blank cells, between row 7 and row 37 and copy the range X:AJ of that row to a worksheet named Master, one after the other starting at row 2.

So for example, if Workbook 1 contains non blank cells in rows 7 and 8 and worksheet 2 contains non blank cells in row 7, 8 and 9, the new sheet will show the data between X:AJ of row 7,8 and then the data of row 7,8,9 from the next workbook etc etc.

If you need anymore info let me know

Cheers