I need help in creating a macro;
in selecting specific cell from different works books 

For Instance I have a workbook1 
and specific cell in workbook2 say "B35" and have figure 12 
likewise in workbook3 say "B35" and figure 42
and Workbook4 say "B35" and figure 53

I need all of them in Workbook1 

as WB2 - B35 = 12, WB 3 = 42 so on...

Can anyone help me?