Paste values form one spreadsheet to antoher

Hi everbody,
I have found many posts similar to what I am trying to accomplish, but nothing that I have been able to modify and make work.
I have two spreadsheets and I need a VBA script that will find a cell with specific name let's say "Light bulb" in spreadsheet2 and then copy the adjacent values (below it) to cell A2 on spreadsheet1.
Would appreciate any help

=====
So as u can see in attached file
I have two sheets; on sheet2 table named products_bulb_designation contains values that need to be pasted to sheet1 to cell A2 below Bulb Designation. The problem is that table products_bulb_designation can be located anywhere within sheet2.