populate last cell value inside shape based on matching another shape with sheet name

Hi experts !
I want matching value inside shape(Rectangle 62) with sheet name , if it's matched , then populate last cell value from column F to inside shape(Rectangle 55)
as I did result in source sheet in shape(Rectangle 55) . every time will add new values in column F for each sheet then will change the last cell value when populate inside shape(Rectangle 55) based on matching value inside shape(Rectangle 62) with sheet name.
thanks