Hi Doug, I got a bit confused with the RSS feed and couldn't get it to work so I have created my own XSLT as follows but what else do I need to make it output as an XML file?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
<xsl:stylesheet 
 version="1.0" 
 xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
 xmlns:msxml="urn:schemas-microsoft-com:xslt"
 xmlns:umbraco.library="urn:umbraco.library" xmlns:Exslt.ExsltCommon="urn:Exslt.ExsltCommon" xmlns:Exslt.ExsltDatesAndTimes="urn:Exslt.ExsltDatesAndTimes" xmlns:Exslt.ExsltMath="urn:Exslt.ExsltMath" xmlns:Exslt.ExsltRegularExpressions="urn:Exslt.ExsltRegularExpressions" xmlns:Exslt.ExsltStrings="urn:Exslt.ExsltStrings" xmlns:Exslt.ExsltSets="urn:Exslt.ExsltSets" 
 exclude-result-prefixes="msxml umbraco.library Exslt.ExsltCommon Exslt.ExsltDatesAndTimes Exslt.ExsltMath Exslt.ExsltRegularExpressions Exslt.ExsltStrings Exslt.ExsltSets ">

<xsl:output method="xml" omit-xml-declaration="yes"/>
<xsl:param name="currentPage"/>
<xsl:template match="/">
<xsl:value-of select="umbraco.library:ChangeContentType('text/xml')"/>
<sites>
 <xsl:for-each select="umbraco.library:GetXmlNodeById(1106)/node [string(data [@alias='umbracoNaviHide']) != '1']">
                <site>
                        <sitename><xsl:value-of select="@nodeName" /></sitename>
                        <siteurl><xsl:value-of select="data [@alias = 'websiteurl']" /></siteurl>
                </site>
        </xsl:for-each>
</sites>
</xsl:template>
</xsl:stylesheet>

Please ignore this, I remembered I have already asked this before.

I now have this working correctly using the following code, it now randomly pulls in 3 website links but the last thing I need to do is make it so that it doesn't pull in a link to the current page if this is possible. Therefore if I am currently on http://www.mytestsite.com/default.aspx then I do not want it to list a link to http://www.mytestsite.com. Anyone know if this is possible and how I would go about doing this? I'm assuming I would need some sort of IF statement that checks the current URL and compares it to the ones in the list?

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
<xsl:stylesheet 
    version="1.0" 
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
    xmlns:msxml="urn:schemas-microsoft-com:xslt"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt"
    xmlns:umbraco.library="urn:umbraco.library"
    xmlns:randomTools="http://www.umbraco.org/randomTools"
    exclude-result-prefixes="msxml umbraco.library msxsl randomTools">
<xsl:output method="xml" omit-xml-declaration="yes"/>
<xsl:param name="currentPage"/>

<xsl:variable name="numberOfItems" select="number(3)"/>

<xsl:template match="/">
  <!-- start writing XSLT -->
  <xsl:variable name="MyFeed" select="umbraco.library:GetXmlDocumentByUrl('http://www.testing.co.uk/test-sites.aspx')" />
  <ul>
    <xsl:for-each select="$MyFeed/sites/site">
<xsl:sort select="randomTools:GetRandom(0,count($MyFeed/sites/site))" order="ascending" />
<xsl:if test="position() &lt;= $numberOfItems">
 <li>
 <a target="_blank">
 <xsl:attribute name="href">
 <xsl:value-of select="siteurl" />
 </xsl:attribute><xsl:value-of select="sitename" />
 </a>
 </li>
</xsl:if> 
    </xsl:for-each>
  </ul>
</xsl:template>

<msxsl:script language="c#" implements-prefix="randomTools">
    <msxsl:assembly href="../bin/umbraco.dll"/>
    <![CDATA[
        /// <summary>
        /// Gets a random integer that falls between the specified limits
        /// </summary>
        /// <param name="lowerLimit">An integer that defines the lower-boundary of the range</param>
        /// <param name="upperLimit">An integer that defines the upper-boundary of the range</param>
        /// <returns>A random integer within the specified range</returns>
        public static int GetRandom(int lowerLimit,int upperLimit) {
            Random r = umbraco.library.GetRandom();
            int returnedNumber = 0;
            lock (r)
            {
                returnedNumber = r.Next(lowerLimit, upperLimit);
            }
            return returnedNumber;
        }
    ]]>
  </msxsl:script>
</xsl:stylesheet>

Once again, I have managed to resolve it using the following code, thanks Doug, I shall mark your answer as the solution:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
<xsl:stylesheet 
    version="1.0" 
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
    xmlns:msxml="urn:schemas-microsoft-com:xslt"
    xmlns:msxsl="urn:schemas-microsoft-com:xslt"
    xmlns:umbraco.library="urn:umbraco.library"
    xmlns:randomTools="http://www.umbraco.org/randomTools"
    exclude-result-prefixes="msxml umbraco.library msxsl randomTools">

<xsl:output method="xml" omit-xml-declaration="yes"/>
<xsl:param name="currentPage"/>

<xsl:variable name="numberOfItems" select="number(3)"/>

<xsl:template match="/">
 <xsl:variable name="url" select="concat('http://',umbraco.library:RequestServerVariables('HTTP_HOST'))" />
  <xsl:variable name="MyFeed" select="umbraco.library:GetXmlDocumentByUrl('http://www.testsite.co.uk/test-sites.aspx')" />
  <ul>
    <xsl:for-each select="$MyFeed/sites/site [siteurl !=$url] ">
<xsl:sort select="randomTools:GetRandom(0,count($MyFeed/sites/site))" order="ascending" />

<xsl:if test="position() &lt;= $numberOfItems">

      <li><a target="_blank">
 <xsl:attribute name="href">
 <xsl:value-of select="siteurl" />
 </xsl:attribute><xsl:value-of select="sitename" />
 </a>
 </li>

</xsl:if> 
    </xsl:for-each>
  </ul>
</xsl:template>

<msxsl:script language="c#" implements-prefix="randomTools">
    <msxsl:assembly href="../bin/umbraco.dll"/>
    <![CDATA[
        /// <summary>
        /// Gets a random integer that falls between the specified limits
        /// </summary>
        /// <param name="lowerLimit">An integer that defines the lower-boundary of the range</param>
        /// <param name="upperLimit">An integer that defines the upper-boundary of the range</param>
        /// <returns>A random integer within the specified range</returns>
        public static int GetRandom(int lowerLimit,int upperLimit) {
            Random r = umbraco.library.GetRandom();
            int returnedNumber = 0;
            lock (r)
            {
                returnedNumber = r.Next(lowerLimit, upperLimit);
            }
            return returnedNumber;
        }
    ]]>
  </msxsl:script>

</xsl:stylesheet>

is working on a reply...