Glyn, welcome to Powershell.org. Please take a moment and read the very first post on top of the list of this forum: Read Me Before Posting! You’ll be Glad You Did!.

When you post code or error messages or sample data or console output format it as code, please.
In the “Text” view you can use the code tags “PRE“, in the “Visual” view you can use the format template “Preformatted“. You can go back edit your post and fix the formatting – you don’t have to create a new one.
Thanks in advance.

Seems you just need to move your assignment of members inside the groups loop?

<#Setting up object variables
to be used for AD lookup#>
$TIME = [datetime]::today.adddays(-$DAYS)
$Groups = (Get-AdGroup -filter * | Where {$_.name -like "*I&O*"} )
<#Connect and cleanup the AD table
Connection remains open for writting#>
<#Begin loop through the ADARRAY for
Variables and begin inserting Rows to table#>

ForEach($Group in $Groups){
    $Arrayofmembers = Get-ADGroupMember -identity $Group.name -recursive | Get-ADUser -Properties samaccountname, displayname, objectclass, name, enabled, UserPrincipalName
    foreach ($Member in $Arrayofmembers) {
        $Name = $Member.name
        $ObjectClass=$Member.Objectclass
        #$DisplayName = $Member.Displayname
        $DisplayName = $Member.DisplayName.replace("'","''")
        $sam = $Member.samaccountname
        $email = $Member.UserPrincipalName.replace("'","''")
        $enabled = $Member.Enabled
        
        $GroupName
        $Name
        $ObjectClass
        $DisplayName
        $sam
        $Enabled
        $email
    }
}

Good. Yeah I think you had everything you needed, just needed to move the $arrayofmembers assignment inside the group loop. I wasn’t sure what the variables at the bottom were, I assumed placeholder for where you write to SQL.

Also, put the output in the PSObject:

<#Setting up object variables
to be used for AD lookup#>
$TIME = [datetime]::today.adddays(-$DAYS)
$Groups = (Get-AdGroup -filter * | Where {$_.name -like "*I&O*"} )
<#Connect and cleanup the AD table
Connection remains open for writting#>
<#Begin loop through the ADARRAY for
Variables and begin inserting Rows to table#>

$results = ForEach($Group in $Groups){
    $Arrayofmembers = Get-ADGroupMember -identity $Group.name -recursive | Get-ADUser -Properties samaccountname, displayname, objectclass, name, enabled, UserPrincipalName
    foreach ($Member in $Arrayofmembers) {
       [PSCustomObject]@{
              Name        = $Member.name
              ObjectClass = $Member.Objectclass
              DisplayName = $Member.DisplayName.replace("'","''")
              Sam         = $Member.samaccountname
              Email       = $Member.UserPrincipalName.replace("'","''")
              Enabled     = $Member.Enabled
       }
    }
}

$results