Usually, the underlying concept for creating data tables is that the data of worksheet is used for one node in the model – implying that one node only references one excel sheet.
This is the case for most data tables. However, there is one way to create datatables in one worksheet that contain the information for multiple nodes. The layout of this data table is similar to the 2D Tables, however Column A now doesn‘t reference a dimension anymore.
Instead of defining a dimension, type $Node into cell A1.
Then, fill the column with the names of the nodes that you want to create a data entry for.
This approach will make your excel sheet more organized, as you don‘t have to create as many worksheets. However, that would of course work, too.