Ahh. Do you think what I want is impossible?

I wish I could get the information to update live into 1 table. The real spreadsheets have userforms to add records, so a new line is made per record. Would be great for that line to auto update to a table on a separate workbook (without VBA So the user doesn't need to have the other workbook open), and as each user adds a record it adds to the same table in order... But I can't see how that is possible