I have one workbook I call test suite. I need to reference a worksheet from
other workbooks which are test cases for software products. then autopoulate
a worksheet in the test suite workbook. The formatting is the same for all
the worksheets, including the suite worksheet. No calcuations are needed, I
just want the data in the suite worksheet, to match the data in the other
worksheets. Basically working the same way as grouping worksheets in a file,
if I update one worksheet, it will automatically update all the worksheets.
The thought is, once it's programmed, anytime I open the suite workbook, I
can update it, to pull the data from the other workbooks worksheets (test
cases). Thank You