Brownfields Redevelopment Enhancement Act - Amends the Housing and Community Development Act of 1974 to authorize the Secretary of Housing and Urban Development to make competitive grants only to eligible public entities and Indian tribes for carrying out projects and activities to assist the development and redevelopment of brownfield sites, including mine-scarred lands.