INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from) Posted 16/05/2021 by jiangws & filed under VBA. Excel INDIRECT function – basic uses and formula examples (ablebits.com)…