Connecting my ADSL router on the network

I have got an ADSL Modem router, through which I connect to the internet. I now want to share it to about 24 other computers on the network. My ISP gateway is 192.168.1.1. The IP address is obtained automatically, usually 192.168.1.2. My computer operate on manually assigned IPs from 192.168.0.XX through 254 with a subnet mask of 255.255.255.0. I tried connecting the ethernet port on the router to the 24 port switch through a CAT5E patch cable, but had no success with internet on the computers. I tried changing the IP address in the LAN settings of the routerof the router to 192.168.0.2 , but then I wasn't able to get my internet connected even on a stand alone machine, which was initially possible through the old IP address. Can some please help by letting me understand how these settings are to be done so that I can get the internet on all my machines. Do I need to change the IP address of my workgroup computers, something that I would like to avoid. Thanx