open worksheets of unknown count in same workbook

[Princy557]

HI,
How would I manage to open a list of x number of worksheets all in the same workbook, access a couple of fields and add them to a summary field on a new workbook.

The worksheets are going to be fixed format titles, such as Invoice 20200811-01, Invoice 20200812-02
How do I work out how many there are, or do I just scan in some way.
IS it possible, is it using Basic?

Any thoughts?
Regards

[SuperTech]

Yes, it is possible by using BasicMaker scripts. Please refer to the BasicMaker manual for the development of such a script to achieve this task.

Thanks

[Princy557]

HI Supertech,

Thanks, however I had hoped for a few more hints on the subject.
But never mind, thanks for responding

[martin-k]

Check out the "Worksheets" collection in the BasicMaker manual. It lets you enumerate all worksheets of a workbook.

[Princy557]

Thanks Martin-k
Will feedback later, sorry but probably with a follow up question.

[Princy557]

Well I've pratted about for quite a few hours but up to now have not managed to so what I want.
If someone has the time to spend 10 minutes or what you can spare to tell how to do it please.
I have done nothing more that confuse myself with all this modern referencing and linking to other worksheets.
If you know please let me know.
I also need it to change a cell in the same row to the current date to indicate last time accessed.

Original Post was:

How would I manage to open a list of x number of worksheets all in the same workbook, access a couple of fields and add them to a summary field on a new workbook.

The worksheets are going to be fixed format titles, such as Invoice 20200811-01, Invoice 20200812-02
How do I work out how many there are, or do I just scan in some way.
IS it possible, is it using Basic?