I have got a workbook wiht 10 sheets that I want to make
a summary of on a new shteet

I need a macro to copy Range B1:C up to where the cells
with data ends in the first sheet to the new sheet then
go back to the next sheet and copy the same range (the
amount of lines can differ)and paste where in the frist
sell with no data underneath the first copy paste data
Hope I make sense. The sheets has got diferendt names
like Floraland, JFK, Franay.