I have been tasked to create a spreadsheet for weekly salary calculations of every company worker. I want to create a spreadsheet with one sheet for every week number of 2022 and name it accordingly. Since I'd have to create 52 sheets named "WN 01" to "WN52" I was looking for a shorter way to do this.
But what's even more time consuming is using data of all these sheets. What I want is a table like this:
|= 'WN01' !$A$1||= 'WN01' !$B$1||= 'WN01' !$C$1|
|= 'WN02' !$A$1||= 'WN02' !$B$1||= 'WN02' !$C$1|
|= 'WN03' !$A$1||= 'WN03' !$B$1||= 'WN03' !$C$1|
|= 'WN04' !$A$1||= 'WN04' !$B$1||= 'WN04' !$C$1|
|= 'WN52' !$A$1||= 'WN52' !$B$1||= 'WN52' !$C$1|
Is there a way to dynamically/automatically change the used sheet name? Is there a script or add-on I could use that basically adds +1 to the sheet name used in every row? I tried using a macro to do this, but that wasn't very successfull.
I hope you can help me with my problem!