software

How do I get datas from ALL of the worksheet within the file into a
quot;master worksheetquot;. REMEMBER ALL WORKSHEETS

In the master worksheet:
Column A = worksheet name (example quot;Sheet 1quot;)
Column B = get data in cell B1 from each worksheet
Column C = get data in cell B2 from each worksheet
Column D = get data in cell B3 from each worksheet
Column E = get data in cell K20 from each worksheet
Column F = get data in cell C26 from each worksheet--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: www.excelforum.com/member.php...oamp;userid=31032
View this thread: www.excelforum.com/showthread...hreadid=525392Hi dannyboy213

Create links to the cells with this macro
www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;dannyboy213quot; gt; wrote in message
...
gt;
gt; How do I get datas from ALL of the worksheet within the file into a
gt; quot;master worksheetquot;. REMEMBER ALL WORKSHEETS
gt;
gt; In the master worksheet:
gt; Column A = worksheet name (example quot;Sheet 1quot;)
gt; Column B = get data in cell B1 from each worksheet
gt; Column C = get data in cell B2 from each worksheet
gt; Column D = get data in cell B3 from each worksheet
gt; Column E = get data in cell K20 from each worksheet
gt; Column F = get data in cell C26 from each worksheet
gt;
gt;
gt; --
gt; dannyboy213
gt; ------------------------------------------------------------------------
gt; dannyboy213's Profile: www.excelforum.com/member.php...oamp;userid=31032
gt; View this thread: www.excelforum.com/showthread...hreadid=525392
gt;