Match worksheet problem

[ScreaminPain]

Hello Board...

I need to import data into master sheet from another sheet in the same workbook. The imported data is is located in the same row and cell number on all sheets in the workbook.

I need to MATCH a cell on the master with a SHEET name and then import the correct data for that match. I imagine, it boils down to how to match a worksheet rather than a table within a sheet.

I hope the image below is veiwable. The master sheet contains everything from column A:R. A different sheet labeled SFO contains the data from S:Y. I want to place the data from S3:Y13 (found on a different sheet) beginning at cell D8. Cell A4 is the reference and that cell changes daily, so I need to match A4 with any of 30 sheets and then import the data. Hopefully, I made myself clear. Any assistance is greatly appreciated.....

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 44px"><COL style="WIDTH: 152px"><COL style="WIDTH: 32px"><COL style="WIDTH: 34px"><COL style="WIDTH: 30px"><COL style="WIDTH: 31px"><COL style="WIDTH: 29px"><COL style="WIDTH: 32px"><COL style="WIDTH: 32px"><COL style="WIDTH: 29px"><COL style="WIDTH: 34px"><COL style="WIDTH: 32px"><COL style="WIDTH: 29px"><COL style="WIDTH: 28px"><COL style="WIDTH: 32px"><COL style="WIDTH: 28px"><COL style="WIDTH: 12px"><COL style="WIDTH: 50px"><COL style="WIDTH: 58px"><COL style="WIDTH: 43px"><COL style="WIDTH: 131px"><COL style="WIDTH: 147px"><COL style="WIDTH: 61px"><COL style="WIDTH: 68px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD><TD>N</TD><TD>O</TD><TD>P</TD><TD>Q</TD><TD>R</TD><TD>S</TD><TD>T</TD><TD>U</TD><TD>V</TD><TD>W</TD><TD>X</TD><TD>Y</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt">overall</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt">H/A</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt" colSpan=7>Last 3 gm's</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 9pt">BP</TD><TD></TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #666699; FONT-FAMILY: Cambria; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">SAN FRANCISCO GIANTS</TD><TD style="BACKGROUND-COLOR: #666699; COLOR: #ffffff"></TD><TD style="BACKGROUND-COLOR: #4f81bd"></TD><TD style="BACKGROUND-COLOR: #666699"></TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 9pt">LAST 10 GMS.</TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 9pt">odds</TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 9pt">o/u</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD></TD><TD style="TEXT-ALIGN: left; FONT-FAMILY: Cambria">Team Pitching</TD><TD></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">ERA</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Whip</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">baa</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">rank</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Whip</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">ERA</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Whip</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">baa</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">IP</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Rn's</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">TB's</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">BB</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">ERA</TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">5/1</TD><TD style="FONT-SIZE: 9pt">SF</TD><TD style="FONT-SIZE: 9pt">W 5-2</TD><TD style="FONT-SIZE: 9pt">Matt Cain (R)</TD><TD style="FONT-SIZE: 9pt">Jordan Zimmermann (R)</TD><TD style="FONT-SIZE: 9pt">W 114</TD><TD style="FONT-SIZE: 9pt">O 6.5 -107</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-WEIGHT: bold">SFO</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">M BUMGARNER</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">(L)</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">6.17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.76</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">0.323</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">147</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.47</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">4.71</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.37</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">#N/A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 8pt">4.34</TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/30</TD><TD style="FONT-SIZE: 9pt">SF</TD><TD style="FONT-SIZE: 9pt">L 1-2</TD><TD style="FONT-SIZE: 9pt">Jonathan Sanchez (L)</TD><TD style="FONT-SIZE: 9pt">John Lannan (L)</TD><TD style="FONT-SIZE: 9pt">L 115</TD><TD style="FONT-SIZE: 9pt">U 7.5 -104</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-WEIGHT: bold">WAS</TD><TD style="TEXT-ALIGN: left; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">T GORZELANNY</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">(L)</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">3.97</TD><TD style="BACKGROUND-COLOR: #ffffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">#N/A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">0.195</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">40</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.05</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">2.60</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">1.10</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">#N/A</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ffcc99; FONT-SIZE: 8pt">3.48</TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/29</TD><TD style="FONT-SIZE: 9pt">SF</TD><TD style="FONT-SIZE: 9pt">W 3-0</TD><TD style="FONT-SIZE: 9pt">Tim Lincecum (R)</TD><TD style="FONT-SIZE: 9pt">Jason Marquis (R)</TD><TD style="FONT-SIZE: 9pt">W 146</TD><TD style="FONT-SIZE: 9pt">U 6.5 110</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/28</TD><TD style="FONT-SIZE: 9pt">NYM</TD><TD style="FONT-SIZE: 9pt">W 4-3</TD><TD style="FONT-SIZE: 9pt">Chris Capuano (L)</TD><TD style="FONT-SIZE: 9pt">Livan Hernandez (R)</TD><TD style="FONT-SIZE: 9pt">W 102</TD><TD style="FONT-SIZE: 9pt">U 8 -106</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center">Gm #</TD><TD>Team</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/27</TD><TD style="FONT-SIZE: 9pt">NYM</TD><TD style="FONT-SIZE: 9pt">L 3-6</TD><TD style="FONT-SIZE: 9pt">R.A. Dickey (R)</TD><TD style="FONT-SIZE: 9pt">Tom Gorzelanny (L)</TD><TD style="FONT-SIZE: 9pt">L -103</TD><TD style="FONT-SIZE: 9pt">O 8.5 -117</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">901</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">SAN FRANCISCO GIANTS</TD><TD></TD><TD style="TEXT-ALIGN: center">x</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/26</TD><TD style="FONT-SIZE: 9pt">NYM</TD><TD style="FONT-SIZE: 9pt">L 4-6</TD><TD style="FONT-SIZE: 9pt">Chris Young (R)</TD><TD style="FONT-SIZE: 9pt">Jordan Zimmermann (R)</TD><TD style="FONT-SIZE: 9pt">L -110</TD><TD style="FONT-SIZE: 9pt">O 7.5 -108</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #000000; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">902</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-FAMILY: Cambria; FONT-SIZE: 9pt; FONT-WEIGHT: bold">WASHINGTON NATIONALS</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/25</TD><TD style="FONT-SIZE: 9pt">@ PIT</TD><TD style="FONT-SIZE: 9pt">L 2-4</TD><TD style="FONT-SIZE: 9pt">John Lannan (L)</TD><TD style="FONT-SIZE: 9pt">Paul Maholm (L)</TD><TD style="FONT-SIZE: 9pt">L 120</TD><TD style="FONT-SIZE: 9pt">U 8 -110</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/24</TD><TD style="FONT-SIZE: 9pt">@ PIT</TD><TD style="FONT-SIZE: 9pt">W 6-3</TD><TD style="FONT-SIZE: 9pt">Jason Marquis (R)</TD><TD style="FONT-SIZE: 9pt">Kevin Correia (R)</TD><TD style="FONT-SIZE: 9pt">W 120</TD><TD style="FONT-SIZE: 9pt">O 8 -107</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/23</TD><TD style="FONT-SIZE: 9pt">@ PIT</TD><TD style="FONT-SIZE: 9pt">L 2-7</TD><TD style="FONT-SIZE: 9pt">Livan Hernandez (R)</TD><TD style="FONT-SIZE: 9pt">Jeff Karstens (R)</TD><TD style="FONT-SIZE: 9pt">L 110</TD><TD style="FONT-SIZE: 9pt">O 8.5 -113</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/21</TD><TD style="FONT-SIZE: 9pt">@ STL</TD><TD style="FONT-SIZE: 9pt">L 0-5</TD><TD style="FONT-SIZE: 9pt">Tom Gorzelanny (L)</TD><TD style="FONT-SIZE: 9pt">Kyle Lohse (R)</TD><TD style="FONT-SIZE: 9pt">L 145</TD><TD style="FONT-SIZE: 9pt">U 8 -104</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/20</TD><TD style="FONT-SIZE: 9pt">@ STL</TD><TD style="FONT-SIZE: 9pt">L 3-5</TD><TD style="FONT-SIZE: 9pt">Jordan Zimmermann (R)</TD><TD style="FONT-SIZE: 9pt">Jaime Garcia (L)</TD><TD style="FONT-SIZE: 9pt">L 149</TD><TD style="FONT-SIZE: 9pt">O 7.5 103</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>

 

[UniMord]

You're going to have to use INDIRECT.
For example, you'll enter something like =INDIRECT($A$4 & "!" & ADDRESS(ROW()-5, COLUMN()+14))

I used the "-5" and "+14" to match the coordinates as they appear on your sample spreadsheet. You'll have to adjust them to match their actual positions.

 

[ScreaminPain]

You're going to have to use INDIRECT.
For example, you'll enter something like =INDIRECT($A$4 & "!" & ADDRESS(ROW()-5, COLUMN()+14))

I used the "-5" and "+14" to match the coordinates as they appear on your sample spreadsheet. You'll have to adjust them to match their actual positions.

Yes, it seems as if this should work, but I can't write code and I'm not familiar with the INDIRECT function. I'm not getting the syntax correct.

My imported data is found beginning on column 1 row 55.....the same location on each sheet. My 30 sheets are from ATL:WAS. Using this information can you show me the exact code for placing the data in D8 of my example?

Once again thanks for your attention....

 

[UniMord]

You'll enter: =INDIRECT(ADDRESS(ROW()+47, COLUMN()-3,,,$A$4))
Remember, you're going to have to format the section you enter the formulas in. The dates, for example, are going to appear as numbers, until you format them as dates.

As a bit of friendly advice. It's worth learning a little about what's happening, so that you'll be able to make your own adjustments as needed. Right now, your problem is solved, but if you have no idea what's going on, then the second anything changes on your spreadsheet, you'll be in trouble. It would be worthwhile to get a beginner's Excel book to learn what's going on, from the ground up.

 

[ScreaminPain]

Thank you for your assistance and advice....I totally agree. My first stop today is the library.