Dynamically referencing other tabs

[Speedracer5545]

Hi, 

I am trying to make a reference block that will allow me to dynamically reference a few areas whenever i enter a certain name for a movie theater accounting worksheet

[movie name (A1)]

Week                                                                         | Number

[referencing from name from tab of movie week 1] | [referencing number from tab of movie week 1]

[referencing from name from tab of movie week 2] | [referencing number from tab of movie week 1]

it doesnt accept ( =(A1)!A3 ) to turn it into =moviename!A3 and it would be easier if this information would copy itself on whenever i just change the movie name and i have looked for other ways to make this work and none of them can do this, is this possible or am i wasting my time? sorry if this is confusing or silly

Thanks

[#2 · Accepted solution]

@Speedracer5545 

Try

=INDIRECT("'"&A1&"'!A3")

[#3]

Worked like a charm, Thanks!