Please see attached*workbook.This workbook have multiple data sheets and a SUMMARY sheet.
All data sheet names will be "1" to "99" these names will be listed on a SUMMARY sheet A:A column.
I need a VBA to Copy each sheet data from A1:C1 and paste beside sheet name list B:D column* on* summary sheet.
Example :* Find sheet "35" copy A1:C1 and paste on "SUMMARY' sheet beside "35" in cell B4:D4 search*all existing sheets and fill up summary data.
Thank you for your help.
Bookmarks