How to create multi-spreadsheet scenarios in an excel workbook
 

Can a scenario be created to modify cells in several tabs (spreadsheets) of
an excel workbook?
I have a clomplex model that feeds from more than one spreadsheet (all
spreadsheets are in the same workbook) and when I try to add cells from more
than 1 spreadsheet in the cells to be changed field it only keeps those of
the last spreadsheet I selected or gives me an error.