Excel：如何在多个工作表中显示数据？

I have written a script which creates a complex Excel sheet which contains data from several data sources. The data on each sheet is usually 1-5 rows. It would be great if I could create another sheet which would display the data from the other sheets online (I.e. the overview sheet should change as I change the data sheets). I also need to format the data with various styles and have the overview sheet copy them. Lastly, the data sheets have different column widths.I have written a script which creates a complex