consolidating text tables from various worksheets into one master sheet

Hi,
I have a workbook with 8 separate worksheets. I need to take the text (tables) from these 8 sheets and bring them all into one master worksheet where when I update one of the 8 worksheets, the master worksheet will also include the new row automatically. Any suggestions?

Yes, I've shown how this can be done by formula several times on this forum, but it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete