Auto-populate data to a master worksheet from other sheets in a shared workbook

[Kate_SO]

Hi,
I need to populate a master spreadsheet with data from other worksheets automatically. I also need the data to be input chronologically as it is received as the information is input into the spreadsheet.

Any help would be really appreciated.

Thanks,
Kate

[TMS]

Welcome to the forum

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[Kate_SO]

Hi Again,

Hopefully, the attachment upload is successful.

I've managed to use an older thread to auto-populate data, although it only covers about 10 rows and 10 columns which I'd like to expand to more cells as the data input grows.

I'd also like to keep the data on the master sheet running chronologically and automated as the data is input on the other sheets.

If the upload doesn't work Capture.PNGas pictured, could someone please lend me a hand on what I've missed?! Feeling a little bit silly!

Thanks,
Kate

[jindon]

Try

Please Login or Register  to view this content.