ExcelBanter - reference to consecutive worksheets within a workbook

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - reference to consecutive worksheets within a workbook (https://www.excelbanter.com/new-users-excel/48609-reference-consecutive-worksheets-within-workbook.html)

steeplejack

reference to consecutive worksheets within a workbook

my workbook has a summary page which has a column which refers to consecutive
worksheets which are named by po numbers which are not consecutive.

is there a short way for me to define these within the colum?

All times are GMT +1. The time now is 12:59 AM.