I have 5 sheet in a workbook, and all the sheet contains a field which
contains different name for example:

sheet1 contains 9 fields and sheet2 may contain 11 fields but both may
contain a field called marks which is different position on the 2
sheets. And in marks field if there is a mark of 50 is there in that
then i have to select some more detail of that raw to another sheet.

Finally i need to take some data from all the sheets raws where the
mark is 50.

could you please help me to create the macro for this.

Thanks,
Robin.