Hopefully I can explain this right.

Looking to combine cells of text strings from multiple worksheets into one master worksheet.

Basically 3-D References. But formatted into rows and columns. And referencing a range of worksheets so new worksheets can be added or removed in between the bookends.

Desired output:

| Column 1 | Column 2 | Column 3 |
| --- | --- | --- |
| WS01 Cell B1 | WS02 Cell B1 | WS03 Cell B1 |
| WS01 Cell B2 | WS02 Cell B2 | WS03 Cell B2 |
| WS01 Cell B3 | WS02 Cell B3 | WS03 Cell B3 |

Input: Strings from B1:B3 (should become matching rows separated into columns for each linked worksheet)

Each worksheet ('Worksheet 01:Worksheet 03') follows same format:

| Column B |
| --- |
| WS## Cell B1 |
| WS## Cell B2 |
| WS## Cell B3 |

Attempts:

=CONCAT('Worksheet 01:Worksheet 03'!B1:B3)

Result:

WS01 Cell B1WS01 Cell B2WS01 Cell B3WS02 Cell B1WS02 Cell B2WS02 Cell B3WS03 Cell B1WS03 Cell B2WS03 Cell B3

Please let me know what you think. Thank you for your time.