Get other sheet names into a column
I am creating a simple envelope budgeting sheet. On my first sheet, I
would like to have a list of all the other sheets ('envelopes') and
their balance. Each 'envelope' sheet has its current balance in cell
A7 and I would like to access that as well.
So my first sheet would have something like:
8 | 9
D <name of second sheet| value of A7 on second sheet
E <name of third sheet | value of A7 on third sheet
....
If possible, I would like this to be automatic so when I add another
envelope sheet, its name and A7 value would show up on the first sheet.
Finally, would it be possible to detect a double click on the sheet
name and
then switch to that sheet?
Thanks in advance for any help.
|