I need a VBA script that will allow me to reference a cell(s) in ALL worksheets automatically

I have a workbook that has almost 1500 worksheets. Each worksheet is not set up as a table. Some cells may contain data or text. I am needing to pull specific cells in all worksheets into one workshe...