Dear Friends

Kindly help to export data like name and percentage from all the sheet (30 sheets) to a new file or in a different sheet.

E.g

Name project target ,weeky %, and monthly percent% ,present, absent are there in all sheet but i want to export only Name and monthly percentage to different excel or different sheet in same excel.

Kindly help me..