Finding a same value from cell from one workbook to another workbook

[santhosh Raman]

Hi,

this is my first post here, i am building a macro where the macro will import data based on cell value from the primary workbook. the cell value will be in workbook 1 but the data will be in workbook 2 and sheet name's will also be n the cell value only, i have build the macro on how to copy the data from one workbook to workbook, but i got struck in how to find the matching value from the workbook 1 to workbook 2 in vba. for e.g. if cell A2 has number "754", i want the macro to find the same value across another workbook.