Automatic Data Fetching row wise in Main Sheet if cells are non blank in linked sheet

Hello,

I am preparing a summary sheet which will automatically fetch data from other sheets in same workbook if in coloumn B any data(in rows) is their.

I am attaching the workbook with summary sheet & back up sheet from where i require the data.I am attaching the sample work their are atleat 1000 back up sheet at present i am attaching workbook which had only 3 sheets.

Please help.

Regards

Subroto