Good afternoon everyone

It's been a little while since I have visited the board. Trust all are well.

I have an issue which I am going around in circles trying to solve. I have a workbook containing a summary sheet and active worksheets. I am trying to assign a macro to a button on the front summay sheet, where if teh reference number listed within column A:A is equal to a worksheet name, then I would like to populate the cells on the summary sheet with data held within the related active worksheet. For example, if cell A4 on my summary sheet equals 4321 and I have an active worksheet called 4321, then I want certain cells on the summary sheet (A5, A6, A7, A8, A9....) to be populated with data held within certain cells from active worksheet 4321. Does that make any sense to anyone? I apologise if my description is poor, but if you do undertsand then I appreciate any help.

Many thanks guys

Ivor